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. – Rubén Aug 15 '18 at 23:10

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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