Have a look at
formatconditional format

--
Don Guillett
SalesAid Software

"jimemma" wrote in message
...
i need to make a cell with an expiration date change colors after that
date
has passed.

example: I have a cell with 04/11/05 and I need to make that cell font
turn
from black to red after that date has passed.