changing cell background colors with formulas

  • Thread starter Thread starter postal vet
  • Start date Start date
P

postal vet

Can someone help me to write a formula to change cell background colors based
on a date.
I have created a training spreadsheet to inform me when individuals are due
for training. At my last job, I created the same spreadsheet but now I cannot
remember the formulas I used.
The cells would remain green if training was in toloerance, turn yellow when
training due date was 30 days out and turn red when the due date passed.
I used a nested if function for the dates but can't remember how to change
the colors.
 
Select the range you want to highlight
Use conditional formatting with
FORMULA IS option
Use formula like
($A1-Today)>30
 
This does not work. Besides, using the conditional formatting only allows me
to use one color. I am trying to use three colors: green, yellow and red.
 
You can have upto three conditions and hence three colors.

What condition are your using?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell color changes when date gets closer 2
Tracking due dates 2
Problem with formulas 4
Conditional Format Based on Date 3
training tracker 3
Conditional Formatting Using "OR" 3
auto colored cells with days 3
Conditional Formatting Formula 1

Back
Top