Hi Cris

You can use CF
http://www.contextures.com/xlCondFormat01.html

Post back if you need more help


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


"Chris" wrote in message ...
I'd like to have my excel sheet columns with the dates to change to a
specific color as the date pass's. I've racked my brain thinking of how.
Anyone??