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.
|