Look up "conditional formatting" in Excel help.
--
David Biddulph

"Maneuver" wrote in message
...
I need to change the color of a cell (red to green) if the date entered is
past a certain date