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