Forum Discussion
Date Occuring
Hi All I have a really simple question I think.... I simply want a cell to highlight when a date has occured and/or passed. I have tried =B2-A1<=Today (using a column with =Today() and a colu...
Select the cells with the dates to be highlighted.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
(Or edit the existing, non-working rule)
Select 'Format only cells that contain'.
Leave the first drop-down set to 'Cell Value'.
Select 'less than or equal to' from the second drop-down.
Enter =TODAY() in the box next to it.
Click Format...
Specify the desired formatting.
Click OK, then click OK again.
In Manage Rules, move this rule down to below the row for empty cells.
Hi
Thanks for your response!
However it still hasn't worked 😞
Thanks for your response!
However it still hasn't worked 😞
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.