Google Sheets Checkbox: Change Row Color Automatically

Yes. In Google Sheets, you can change an entire row’s color when its checkbox is checked by applying conditional formatting to the row range with a custom formula. For example, if the checkboxes are in column A and your table begins on row 2, select the rows you want to format, choose Format > Conditional formatting, and use =$A2=TRUE as the custom formula.

How checkbox-based row coloring works

A checkbox in Google Sheets is a cell with a Boolean value: by default, it is TRUE when checked and FALSE when unchecked. Conditional formatting evaluates a rule and changes a cell’s appearance when the rule is true. When the formatting range covers several columns, a formula can look at the checkbox in each row and apply the chosen style across that row.

The key is to use a custom formula with the checkbox column fixed and the row number relative. In =$A2=TRUE, the dollar sign before A keeps the rule looking in column A as it moves across the formatting range. The row number has no dollar sign, so Sheets checks A2 for row 2, A3 for row 3, and so on. This is what makes each row respond to its own checkbox.

The color is a visual formatting effect, not a change to the cell values. Checking or unchecking the box changes the formula result, and conditional formatting updates the row’s appearance. It is useful for task lists, review queues, inventory checks, attendance sheets, and other tables where a checkbox marks a row’s status.

Set up the checkbox and color rule

Suppose column A contains checkboxes and columns B through F contain task details. The table has a header in row 1 and entries from row 2 to row 100. Use these steps in Google Sheets in a web browser:

Select the cells where you want checkboxes, such as A2:A100, then choose Insert > Checkbox. If the checkboxes are already in place, skip this step.
Select the full area that should change color, such as A2:F100. Include every column in the row that you want shaded. You can leave out column A if you want the checkbox cell itself to retain its existing appearance.
Choose Format > Conditional formatting. The conditional-formatting rules panel opens.
Under “Format rules,” choose “Custom formula is.” With checkboxes in A and the selected range starting at row 2, enter =$A2=TRUE.
Under “Formatting style,” choose a fill color and, if helpful, a text color or other style.
Choose Done. Check a box in column A to confirm that the corresponding row changes color; clear it to confirm that the conditional color disappears.

Conditional formatting does not require you to create a different rule for every row. One rule can cover the whole selected range because the relative row reference adjusts as it is applied down the range. If your table has more rows later, extend the rule’s “Apply to range” setting or initially select a range large enough for expected entries.

Make the formula match your layout

Use the first row of the formatting range in the formula. If the range begins at row 2, use =$A2=TRUE; if it begins at row 5, use =$A5=TRUE. A mismatch can make the rule look one row out of place because Sheets adjusts references relative to the range’s starting point.

The column letter must point to the checkbox, not necessarily the first column in the table. If checkboxes are in column D and the format range is A2:F100, use =$D2=TRUE. The dollar sign before D is important: without it, the reference may shift as the rule is evaluated across other columns. Keep the row number relative so each row checks its own box.

You can also format only selected columns. For example, apply the rule to B2:F100 if you want the task details shaded but not the checkbox in column A. The formula still refers to the checkbox column: =$A2=TRUE. The range determines which cells receive the color; the formula determines when they receive it.

Use custom checkbox values

Standard checkboxes use TRUE and FALSE, so the TRUE-based rule is appropriate for ordinary checkboxes. Google Sheets also allows custom checked and unchecked values. This can be useful when a sheet needs labels such as “Done” and “Open” rather than Boolean values, but the conditional-formatting formula must then test the value actually stored in the cell.

To configure custom values, select the checkbox cells and open Data > Data validation. In the checkbox criterion, enable the option for custom cell values and enter the checked and unchecked values you want. The precise controls appear in the data-validation panel or dialog, depending on the current Sheets interface. After changing the values, update the conditional-formatting formula to match the checked value. For example, with a custom checked value of Done in A2:A100, use =$A2="Done".

If the checkbox appears checked but the row does not change color, a custom value is one possibility. Another is that the formula refers to a different column or uses a different spelling, spacing, or capitalization from the cell value. Confirm the checkbox setting and the value it represents before changing the formatting range.

Color rows for more than one status

You can create separate conditional-formatting rules for different states. For instance, one rule can shade checked rows green and another can shade unchecked rows gray. With default checkboxes in column A and a formatting range beginning at row 2, the checked rule is =$A2=TRUE and the unchecked rule is =$A2=FALSE. Choose a different formatting style for each rule.

Use the unchecked rule thoughtfully. If the formatting range includes many empty rows, those rows may also evaluate as unchecked, depending on their contents and the rule. To avoid coloring unused rows, add a condition that requires a key field to be populated. For example, if each real task has a name in column B, a custom formula can combine “checkbox is checked” with “task name is not blank.” With the range starting at row 2, the formula is =AND($A2=TRUE,$B2<>""). This shades checked task rows while leaving rows without a task name unformatted.

Rules can also reflect other criteria, such as a priority or category, but decide which rule should control the appearance when more than one condition is true. In the conditional-formatting panel, review the rule order and formatting styles if a row’s color is not the one you expect. Keep the number of overlapping rules manageable so the sheet remains easy to maintain.

Common problems and quick fixes

Only the checkbox cell changes: The “Apply to range” setting probably covers only column A. Expand it to the complete row area, such as A2:F100.
The wrong row changes: Make the formula’s row number match the first row of the apply range. For a range starting at row 3, start the formula with row 3, not row 2.
Every row gets the same result: Check for a dollar sign before the row number. Use =$A2=TRUE, not =$A$2=TRUE, because the latter always checks the same cell.
The rule never activates: Confirm that the checkbox column is correct and that the checkbox uses the standard TRUE/FALSE values. If it uses custom values, test the exact checked value instead.
Color remains after unchecking: Look for another conditional-formatting rule that also applies to the range, or for a manually applied fill color that is visible when the condition is false. Review Format > Conditional formatting and remove or adjust conflicting rules.
New rows do not get colored: Check whether the new rows fall inside the rule’s “Apply to range.” Expand the range to include them, or use a suitably sized range for the table.

When diagnosing the issue, inspect the rule’s apply range and formula together. They work as a pair: the range identifies which cells can be formatted, while the formula identifies the condition for each row. A correct formula applied to the wrong range, or a correct range paired with a misaligned reference, can produce confusing results.

Conditional formatting versus manual coloring

Manual fill color is fine for a one-time visual mark, but it does not stay synchronized with a checkbox. If you color a row by hand and later uncheck the box, the manually applied color remains until someone removes it. Conditional formatting is the better choice when the color should reflect the current checkbox state automatically.

Conditional formatting also keeps the checkbox value separate from the presentation. You can sort or edit the table without needing to recolor each row manually. If you copy a formatted row, however, check the copied rule’s apply range and references; copied cells can bring along formatting rules or styles you did not intend. For a shared sheet, a consistent range and a small set of clearly named statuses make the setup easier for other editors to understand.

These steps are for Google Sheets in a browser. Excel has its own conditional-formatting interface and rule behavior, so do not assume that the Google Sheets menu path or rule setup transfers exactly. In either program, the general idea is to use a conditional rule tied to the checkbox value, but the specific interface and supported options differ.

Frequently Asked Questions

Can I change the color of the whole row when a checkbox is checked?
Yes. Apply conditional formatting to all the row cells you want colored, then use a custom formula that refers to the checkbox in that row, such as =$A2=TRUE when the checkbox is in A and the range starts on row 2.

Can I color the row without coloring the checkbox cell?
Yes. Set the apply range to the other columns only, such as B2:F100, while keeping the custom formula pointed at the checkbox in column A.

Why does the formula use a dollar sign before the column letter?
The dollar sign locks the checkbox column as the formatting rule moves across the row. Leaving the row number unlocked lets the reference advance to the checkbox on each subsequent row.

Can I use a different color for unchecked rows?
Yes. Add another conditional-formatting rule using the unchecked value, usually FALSE for standard checkboxes, and choose a separate style. Consider adding a nonblank-data condition so empty rows are not colored.

Will the color update when I uncheck the box?
Yes. Conditional formatting recalculates as the checkbox value changes. When the condition is no longer true, that rule’s formatting no longer applies, although a separate rule or manual fill may still affect the row.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.