I am looking to copy over a conditional format that changes the colour of an array of cells when checking a checkbox.

Conditional Formatting 1

This works perfectly fine on the first checkbox. However, when I try to replace all the other checkboxes on the spreadsheet with the conditionally formatted cell by dragging down the box, it then messes up all of the formattings. As seen in the picture below.

Conditional Formatting 2

There has got to be an easier way to do this than to have to create a new rule for every cell. Any help would be greatly appreciated.

1 Answer 1

  • custom formula: =COUNTIF($I2, "=TRUE")


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.