Forum Discussion

Tracey1365's avatar
Tracey1365
Copper Contributor
Dec 22, 2022

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 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.

Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Dec 22, 2022

    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.

     

Resources