Here's my problem.
I have a cell with a checkbox. I can make it turn green when I check it. But I want it to turn green if no conditions are met and turn orange when a condition is met. The condition is that a range of four cells is empty (<>""
). If all of them are empty – then checkbox becomes orange when pressed, if there is anything in any of the four cell then checkbox becomes green when pressed.
Best Answer
Use a custom formula based on
countblank
=countblank(A3:D3) = 4
=countblank(A3:D3) <>4
Rules
Outcome: Green/all blank
Outcome: Orange/at least one cell not blank