I'm trying to have a checkbox change the background color of a range of cells using conditional formatting custom formula =$N123=True. With the range defined in conditional formatting only the first cell changes color when the checkbox is checked. Why would only one cell be effected?

  • What is the range where the conditional formatting was applied? Also add a demo spreadsheet shared with anyone with the link. Aug 15, 2018 at 23:10

1 Answer 1


you need to lock the row number otherwise, it will look for next row and the next row have not the given criteria (TRUE)

custom formula: =COUNTIF($A$1, "=TRUE")

enter image description here


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.