Conditional Formatting not working properly

Copper Contributor

I have a basic conditional formatting formula that makes a cell turn red if the value of the cell is less than or equal to today's date minus 11 months (=EDATE(TODAY(),-11). It is working throughout most of my spreadsheet but in some cells it is not working. How can that be? My cell date value is 12/20/2023. Today is 12/22/2022 and the cell is being highlighted red (my conditional format rule). It makes no sense.

1 Reply



You can try this rule for conditional formatting. I've added A1<>"" to the rule otherwise empty cells would be formatted red.


This is the range the formatting applies to in the example.

conditional formatting.JPG