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.
--
Thanks!

EM

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

--
HTH,
Barb Reinhardt



"moon" wrote:

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.
--
Thanks!

EM

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

HTH,,


"moon" wrote:

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.
--
Thanks!

EM