Conditional Formating

[Debbie]

Hi! I would like to do a conditional format based on today's date.

My cell has a date entered in it. If the date is less than today, I
would like it to format to red font. Can anyone tell me how to do
this?
Thanks!

 

[JP Ronse]

Hi Debbie,

In conditional format enter:
Formula is
=<your cell> < TODAY()
Format font red

Wkr,

JP

 

[Debbie]

Hi Debbie,

In conditional format enter:
Formula is
=<your cell> < TODAY()
Format font red

Wkr,

JP







- Show quoted text -

Thank you JP Ronse! Works great. I am getting the hang of things
little by little.