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.)

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.)

Select the cell.

FormatCFCell Value is: less than =TODAY()

Or Formula is: =cellref<TODAY()


Gord Dibben MS Excel MVP

On Sat, 16 Dec 2006 09:47:01 -0800, Navy Nurse <Navy
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.)

"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.)