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.