Cond format with date

[Guest]

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

 

[RichardSchollar]

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

Hope this helps!

Richard

 

[Gord Dibben]

Select the cell.

Format>CF>Cell 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

 

[Guest]

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