Hi

Use CF
See Debra's site for a example
http://www.contextures.com/xlCondFormat01.html

--
Regards Ron de Bruin
http://www.rondebruin.nl



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