Use a formula of

=A1=TODAY()

and another of

=A1=TODAY()-3

assuming your cell is A1

--
HTH

Bob Phillips

"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.