Forum Discussion
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 ?
1 Reply
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
