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