Conditioanl formating

M

moon

Hello,

I need to schedule some cells to change to a given color (ex. yellow) when
the due date is nearing (say 3 days out), then I need it to change to red
when the due date is here or has passed.

For instance if the due date is 9/12/07, I would like the cell to
automatically change to yellow 3 days prior, and then on the 12th, it should
turn red.

Any help is greately appreciated.
 
B

Barb Reinhardt

Select the cell or cells you want to format. I'm assuming your selecting A1
first.

Format -> Conditional Format

Formula is =today()-A1< 3
Format to YELLOW
Formula is =today() >= A1
Format to RED
 
J

Jim May

you can add two conditions (both using the "Cell Value is" dropdown).
#1 Between =today()-3 =today()-1
#2 Equal to =today()

HTH,,
 
Top