Conditional Formating Based on Date

[Guest]

Hi,

I need some help on conditional formating. What I want to do is change the
color of a cell based on the date, i.e. if the date in the cell is today or
greater I want the cell color to change to red, if the date is 3 days before
the date in the cell I want it to change color to yellow.

 

[Don Guillett]

condition 1 formula is
=a3>=today()
cond 2 etc

 

[Bob Phillips]

Use a formula of

=A1>=TODAY()

and another of

=A1>=TODAY()-3

assuming your cell is A1

 

[Guest]

Thanks, this worked, however I have another issue with this. The cell that
is changing color is the due date, but if I put in a date in the completed
cell i want the due date cell to change to green. I have tried under
conditional formating - formula is if(o12>0), but the color did not change to
green. I even tried to this formula if(o12>n12) and the color still did not
change. I am trying to close the loop so that the due date does not change
to red or yellow after there is a date completed in cell O12.

 

[Bob Phillips]

Use

=AND(O12<>"",A1>=TODAY())

etc.

 

[Guest]

How would I do a Conditional Formating for dates with a between statement for
three different conditions. With today being 06/07/06, the 1st date of
05/24/06 is between today()-4 and today()-15. 06/05/06 is between today()-3
and today()+3. 06/05/06 is between today()+4 and today()+60.

Today: 06/07/06

05/24/06 -14 (hi-lighted in Blue)
06/05/06 -2 (hi-lighted in Yellow)
07/26/06 +49 (hi-lighted in Orange)