Forum Discussion
Conditional Formatting not working properly
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 ...
=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$12This is the range the formatting applies to in the example.