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?

Improve this question
1
  • 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, 2018 at 23:10

1 Answer 1

Reset to default
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

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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