Alright, so I’ve been having this issue for a few hours now and am confident to say that I can’t fix it by myself.
I’ve been playing around with Google Sheets trying to apply Conditional Formatting when another referenced cell is not empty.
Here’s an image of the issue, it will definitely help you understand what I’m trying to do.
However, here’s what happens when I do the following two things (using an IF function to determine the state and then parse the true or false state towards the Conditional Formatting rule), here’s where the broken magic comes into play.
When I set it to
=IF(ISBLANK(B2), false, true), this happens.
But when I reverse it and set it to
=IF(ISBLANK(B2), true, false), this happens again.
I am lost to why this happens as from what you can see in the screenshots, B2 is never empty.
EDIT: For whatever reason, when I set it to
=IF(ISBLANK(B2), true, true), it works as expected, as seen here. I would still like to hear an explanation if anybody has one.