To color a whole row when its checkbox is checked, use a conditional formatting rule with a custom formula that points at the checkbox column with a dollar sign before the letter. With the checkboxes in column B and data in A2:E100, the formula is:
=$B2=TRUE
The rest of this guide shows where to enter it, why the $ is the part that matters, and what went wrong when we left it out.
Tested in Google Sheets. On November 11, 2026 we applied each rule on this page, including the broken ones, to the same five-row task list and checked which cells changed color. How we test
Step by step
- Insert the checkboxes if you don’t have them yet: select B2:B100 and choose Insert > Checkbox.
- Select the rows you want to color, without the header: A2:E100.
- Open Format > Conditional formatting. Check that “Apply to range” shows A2:E100.
- Under “Format cells if…”, choose Custom formula is.
- Type
=$B2=TRUE. The row number must be the first row of the range, here 2. - Pick a fill color under “Formatting style” and click Done.
A checked checkbox holds the value TRUE and an empty one holds FALSE, so the rule is true only on checked rows. In our test, =$B2 on its own worked the same way, because the checkbox value is already TRUE or FALSE. We use =TRUE because it is easier to read.
If you’d rather not type the formula, our conditional formatting formula generator builds it, along with the range, from the column letter.
Why the $ before the column matters
A custom formula is written for the first cell of the range, A2, and Google Sheets moves it to every other cell the same way a copied formula moves. The $ locks what must not move:
| Formula | What it checks from cell D3 | What happened in our test |
|---|---|---|
=$B2=TRUE |
B3: the checkbox of its own row | Whole row colored on checked rows. Correct. |
=B2=TRUE |
E3: the column moves along with the cell | Only column A changed color on checked rows; the other cells were checking the wrong columns. |
=$B$2=TRUE |
B2: always the first checkbox | Every row was colored, because the first box was checked. Unchecking it would have cleared them all. |
So: dollar sign before the column letter, no dollar sign before the row number.
The color appears on the wrong row
This happens when the row in the formula doesn’t match the first row of the range. We applied the rule to A2:E6 but wrote =$B3=TRUE. Every row then looked at the checkbox of the row below it: the first row stayed white even though its box was checked, and the unchecked row underneath it turned green. There was no error message.
Fix: open the rule and compare the two: if “Apply to range” starts at row 2, the formula must say $B2. If you add a header row later, or start the range at row 1, update the formula too.
Found in testing: all three broken versions above failed silently. Google Sheets accepted each rule and simply colored the wrong cells. The quickest check is to tick and untick one box and watch which row reacts.
Color the row only if another condition is also true
Combine the checkbox with any other test inside AND. To highlight checked rows whose amount in column D is over 100:
=AND($B2, $D2>100)
In our list, two rows were checked and both had amounts over 100 (120 and 250), and only those two turned green. Use OR instead of AND to color a row when either condition is true.
Two rules on the same rows
You can add a second rule, for example orange when the status column says “Late”. When both rules are true for the same cell, Google’s help page says the first rule in the list wins, and that is what we saw: with the checkbox rule listed first, rows that were both checked and late stayed green. Drag the rules in the conditional formatting panel to change their order.
Cross out the row instead
The same formula can apply strikethrough instead of a fill color, which is popular for to-do lists. See how to cross out a row when a checkbox is checked.