Forum Discussion
Peter20
Dec 29, 2022Copper Contributor
Conditional Foratting by date
I would like every cell that contains a date before today to change colour. I've used:
Conditional Formatting / Highlight Cells Rules / Less Than / =TODAY() / specify colour
but all cells are the same colour irrespective of the date in the cell.
I've also tried:
Conditional Formatting / New Rule / Format only cells that contain / Less Than / =TODAY()
Again every cell is the same colour irrespective of the date in the cell.
Am I doing something wrong here?
Thank you