Can I program Excel cells to change colour at a set date?

  • Thread starter sunflowermurray
  • Start date
S

sunflowermurray

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

Jerry W. Lewis

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
 
Top