1

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.

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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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