condition 1 formula is
=a3=today()
cond 2 etc
--
Don Guillett
SalesAid Software

"Roy" wrote in message
...
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.