Google Sheets – Combine Checkbox and Conditional Formatting

conditional formattinggoogle sheets

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

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

Rules

Custom Rules


Outcome: Green/all blank

All Blanks


Outcome: Orange/at least one cell not blank

One  not blank