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?
Google Sheets – Use Checkbox to Change Background Color of Cells
conditional formattinggoogle sheets
Related Solutions
This does the trick:
=IF(INDIRECT("R"&ROW()&"C"&COLUMN(),FALSE)=INDIRECT("Default!R"&ROW()&"C"&COLUMN(),FALSE),TRUE,FALSE)
It's not exactly concise, but it works.
You can use a range as a parameter for the ISFORMULA() function.
e.g. If you want to highlight all cells containing formulas in the range A1:J10, then you can use the formula =ISFORMULA(A1:J10) and apply it to the range A1:J10.
Note that this works with normal ranges (e.g. B2:F30), but not with infinite ranges (e.g. B:F).
Related Topic
- Google-sheets – How to change the background color of a cell based on the cell contents using a color lookup sheet
- Google-sheets – Compare value in all cells in a column in Google Sheets
- Google Sheets – Multiple Color Formatting Issue
- Google Sheets – Change Cell Background Color Based on Hex Value
- Google-sheets – Google Sheets – Highlighting Cells if they contain text from another range of cells
Best Answer
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")