Formatconditional formatting, formula is

=A1<TODAY()

select a red pattern/font

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"awilliams" wrote in message
...
i have having trouble finding a function that will allow me to make the
cell
change red if the date that is entered into that cell becomes older than
the
current date. if anyone can help me that would be great.
thanks