Conditional Formatting not working properly

Occasional Visitor

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

@Tracey1365 

=AND(A1<=EDATE(TODAY(),-11),A1<>"")

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

=$A$1:$A$12

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

conditional formatting.JPG