conditional formatting on date where today is > or = datevalue

[Guest]

I want cells in an Excel spreadsheet to highlight when the date in the cells
is equal to the date the spreadsheet is opened, or if the date is overdue.
Have tried conditional formatting formulas with no luck. Ideally when the
sheet is opened I would like any dates that are due or overdue to alert the
user in red.

 

[MartinW]

Hi Ken,

Select all of your dates and go to Conditional Formatting
and select from the dropdowns
Cell Value is
less than or equal to

In the third box put =TODAY()
Select your formatting color and OK out

Then go back through the process to make sure that Excel hasn't
been helpful and added some double quotes for you.
Something like ="TODAY()"
If it has just delete the quotes and all should be well.

HTH
Martin

 

[Guest]

Hi Martin,

It worked great, many thanks

Ken

Hi Ken,

Select all of your dates and go to Conditional Formatting
and select from the dropdowns
Cell Value is
less than or equal to

In the third box put =TODAY()
Select your formatting color and OK out

Then go back through the process to make sure that Excel hasn't
been helpful and added some double quotes for you.
Something like ="TODAY()"
If it has just delete the quotes and all should be well.

HTH
Martin

 

[MartinW]

You're welcome Ken

Hi Martin,

It worked great, many thanks

Ken