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.

1 Answer 1


Use a custom formula based on countblank

  • Green = =countblank(A3:D3) = 4
  • Orange = =countblank(A3:D3) <>4


Custom Rules

Outcome: Green/all blank

All Blanks

Outcome: Orange/at least one cell not blank

One  not blank

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.