conditional formatting on date where today is or = datevalue
 

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.

conditional formatting on date where today is or = datevalue
 

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


"Ken" wrote in message
...
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.

conditional formatting on date where today is or = datevalue
 

Hi Martin,

It worked great, many thanks

Ken

"MartinW" wrote:

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


"Ken" wrote in message
...
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.

conditional formatting on date where today is or = datevalue
 

You're welcome Ken


"Ken" wrote in message
...
Hi Martin,

It worked great, many thanks

Ken

"MartinW" wrote:

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


"Ken" wrote in message
...
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.