Use a conditional format. For instane you might format as yellow, then
set a conditional format based on the formula
=TODAY()=datecell
to apply the green color.

Jerry

sunflowermurray wrote:

I want certain cells to change from yellow to green when a date contained
within those cells is reached. Excel version 2003