On Oct 11, 8:59*am, "JP Ronse" wrote:
Hi Debbie,

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

Wkr,

JP

"Debbie" wrote in message

...



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!- Hide quoted text -

- Show quoted text -


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