Use checkbox to change the background color of a range of cells in Google Sheets

Question

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?

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")