conditional formatting ... shade cell ... older than today
 

How can I use conditional formatting to shade the cell if its value is older
than today?

conditional formatting ... shade cell ... older than today
 

Use a formula of

=A1<TODAY()

assuming the cell is A1.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mirsten Choiple" wrote in message
...
How can I use conditional formatting to shade the cell if its value is
older
than today?

conditional formatting ... shade cell ... older than today
 

If you want to use the default Cell Value Is dialogs rather than Formula is,
then

Select all the cells you want to format and do

format=Conditional Format

Cell value is Less than =today()-1

if you want to allow for blank cells

Cell value is between 1 and =today()-1

--
Regards,
Tom Ogilvy

"Mirsten Choiple" wrote in message
...
How can I use conditional formatting to shade the cell if its value is
older
than today?