ExcelBanter - Conditional Formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formating (https://www.excelbanter.com/excel-worksheet-functions/245185-conditional-formating.html)

Debbie[_4_]

Conditional Formating

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

Conditional Formating

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!

Debbie[_4_]

Conditional Formating

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.

All times are GMT +1. The time now is 02:22 AM.