1

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
0

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 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.