Forum Discussion

Igrecpoint's avatar
Igrecpoint
Copper Contributor
Sep 25, 2024

Conditional Formating / Double condition not working (with dates)

Good morning/afternoon/night,

I'm trying to apply the double condition formatting in Excel, but it is not working, while apply separately it is working ... which is Strange.
My custom formula is : 

 

=and(I$2<=$B3;$B3<I$1)

 

 

You can see in the screenshot bellow that the intersection is good on I3 and O4 but they're not yellow, not sure what I am missing here. Any clue ?

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 25, 2024

    Igrecpoint 

    Try to place the rule with combined formula on first place. Conditional Formatting applies format to the cell based on first rule which returns TRUE and ignore other rules.

    and

Resources