Checkboxes in Google Sheets are tiny little spell buttons. Click one, and your sheet can instantly mark a task as done, flag an order as packed, or make an entire row stand out.

In this tutorial, you’ll learn how to highlight a whole row when a checkbox is checked in Google Sheets using conditional formatting. No scripts. No add-ons. Just one clean formula.

What You’ll Build

Let’s say you have a simple task list:

• Column A: Done?
• Column B: Task
• Column C: Owner
• Column D: Due Date

When the checkbox in column A is checked, the entire row from A through D will turn green. This works beautifully for to-do lists, content calendars, habit trackers, order lists, and any sheet where “done” deserves a little glow-up.

Step 1: Add Checkboxes to Google Sheets

1. Select the cells where you want checkboxes, such as A2:A20.
2. Go to Insert > Checkbox.
3. Google Sheets will add a checkbox to each selected cell.

Behind the curtain, a checked checkbox equals TRUE. An unchecked checkbox equals FALSE. That is the tiny bit of spreadsheet magic we’ll use in the formatting rule.

Step 2: Select the Rows You Want to Format

Highlight the full range you want the formatting to affect. For this example, select:

A2:D20

Do not select only the checkbox column unless you only want the checkbox cell to change color. To highlight the whole row, your selected range needs to include the whole row area you want styled.

Step 3: Open Conditional Formatting

1. With A2:D20 selected, go to Format > Conditional formatting.
2. In the sidebar, look for Format cells if.
3. Choose Custom formula is.

This is where the spell gets cast.

Step 4: Use This Custom Formula

Enter this formula:

=$A2=TRUE

Then choose a formatting style, such as a light green fill, gray text, or bold text. Click Done.

Now, whenever the checkbox in column A is checked, Google Sheets highlights the whole row.

Why This Formula Works

The dollar sign in $A2 locks the rule to column A. That tells Google Sheets, “For every cell in this row, check the checkbox value in column A.”

The row number stays flexible. So on row 2, Google Sheets checks A2. On row 3, it checks A3. On row 4, it checks A4, and so on.

If you accidentally use A2=TRUE without the dollar sign, the formatting may drift across columns and behave like a mischievous spreadsheet goblin.

Excel Note

This exact checkbox method is for Google Sheets. Excel can also highlight rows based on checkbox-style values, but Excel checkboxes usually need to be linked to cells first. If you are working in Excel, the conditional formatting idea is similar, but the checkbox setup is different.

Common Mistakes

The checkbox cell changes, but not the whole row

Check your “Apply to range” box. It should include the whole row range, such as A2:D20, not just A2:A20.

Every row highlights at once

Make sure your formula starts with the first row of your selected range. If your range starts at row 2, use =$A2=TRUE. If your range starts at row 5, use =$A5=TRUE.

The rule does nothing

Confirm the checkboxes are real Google Sheets checkboxes from Insert > Checkbox. Typed words like “done” or “yes” will not work with this exact formula.

Quick Formula Recap

To highlight a row when a checkbox is checked in Google Sheets, select your row range, open conditional formatting, choose Custom formula is, and use:

=$A2=TRUE

That’s it. One checkbox, one formula, and your task list suddenly looks like it knows what it’s doing.