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