Say your input date is in A1, then FormatConditional Formatting,
change to Formula Is and enter =A1<TODAY() and then format as required.

Hope this helps!

Richard



Navy Nurse wrote:
How do you program a cell to change colors by the current date? example: I
need a cell to change color when the input date becomes less than today's
date. (a CPR card expiration date is entered, when todays date is past the
expiration date, I need the cell to turn red to notify that it is expired.
The date used to judge must be the current date, whatever todays date is vs.
a specific date entered.)