Mark Rows Complete Automatically With a Checkbox in Google Sheets

A checkbox can turn a basic Google Sheets task list into a much easier tracker.

Instead of manually changing colors or typing "Done," you can check one box and let conditional formatting automatically change the entire row, cross out the task, or visually separate completed work from unfinished tasks.

QUICK ANSWER

Add a checkbox, then format the row when the checkbox is TRUE

Add checkboxes with Insert > Checkbox. Then select your task table, open Format > Conditional formatting, choose Custom formula is, and use a formula such as =$D2=TRUE.

Example Task Tracker

For this example, the sheet has four columns:

Column	Purpose
A - Task	The work that needs to be completed
B - Owner	Person responsible for the task
C - Due Date	Deadline
D - Complete	Checkbox used to mark the task finished

Add a Checkbox Column

Google Sheets includes built-in checkboxes, so you do not need to create symbols or type TRUE and FALSE manually.

Add the checkboxes

1. Select the cells in the Complete column, for example D2:D1000.
2. Open Insert.
3. Choose Checkbox.
4. Google Sheets adds a checkbox to every selected cell.

By default, an unchecked checkbox represents FALSE and a checked checkbox represents TRUE.

EGGLOVER TIP

Add the checkbox to more rows than you currently need if the tracker will keep growing. That way, new tasks already have a completion control ready.

Change the Entire Row When a Task Is Complete

The checkbox itself only changes between checked and unchecked. Conditional formatting is what makes the rest of the row react.

Create the completed-row rule

1. Select your task table, for example A2:D1000.
2. Open Format > Conditional formatting.
3. Choose Custom formula is.
4. Enter the formula below.
5. Choose a light green fill or another completed style.
6. Click Done.

=$D2=TRUE

The dollar sign locks the rule to column D while the row number changes for each task. When D2, D3, D4, and the other checkbox cells become TRUE, the corresponding row receives the formatting.

Cross Out Completed Tasks

A color change works well, but a strikethrough can make the distinction between finished and unfinished work even clearer.

You have two simple options.

Cross out the entire row

Apply the conditional-formatting rule to A2:D1000 and choose strikethrough as part of the formatting style.

Cross out only the task name

Apply the same rule only to A2:A1000 so the Task column is crossed out while dates and owners stay easier to read.

Same formula, different apply range

You can still use =$D2=TRUE. The cells that change depend on the range you selected before creating the rule.

What the Finished Task Tracker Looks Like

Once the rule is active, checking a box immediately changes the corresponding row.

Checkbox	Row Result
Unchecked	Task remains in its normal unfinished style.
Checked	The completed formatting appears automatically.

Use a Different Checkbox Column

Your checkbox does not have to be in column D.

If the checkbox is in column E instead, change the formula to:

=$E2=TRUE

The important part is matching the column letter in the formula to the actual checkbox column.

What If You Use Custom Checkbox Values?

Google Sheets also allows custom checkbox values through Data validation.

For example, you could make a checked checkbox return Done instead of TRUE and an unchecked checkbox return Open.

If you do that, your conditional-formatting formula needs to check for the custom value instead:

=$D2="Done"

Why Is the Wrong Row Changing?

Wrong starting row

If your data begins on row 3, your formula should normally begin with D3 rather than D2.

Wrong checkbox column

Make sure the formula points to the column that actually contains the checkboxes.

Wrong apply range

Check that the conditional-formatting range begins on the same row used by the formula.

Custom checkbox values

A customized checkbox may return text instead of TRUE or FALSE.

Use Checkboxes Beyond Task Lists

Google specifically supports using checkboxes with formulas, filters, charts, and pivot tables, so this idea can extend beyond a basic to-do list.

Tracker	Checkbox Meaning
Task Tracker	Task completed
Invoice Tracker	Invoice paid
Content Calendar	Content published
Review Checklist	Item approved or checked

Related Google Sheets Guides

Flag Missing Data Automatically in Google Sheets

Highlight incomplete tasks before important information is missed.

Highlight Overdue Dates Automatically in Google Sheets

Automatically flag deadlines that need attention.

Find and Fix Duplicate Invoice Numbers in Google Sheets

Find repeated IDs and clean duplicate spreadsheet records.

Frequently Asked Questions

Can a checkbox change the color of a row in Google Sheets?

Yes. Use conditional formatting with a custom formula that checks whether the checkbox is selected.

What value does a checked Google Sheets checkbox have?

By default, a checked checkbox is TRUE and an unchecked checkbox is FALSE.

Can I automatically cross out a task when I check the box?

Yes. Use the checkbox as the conditional-formatting trigger and select strikethrough as part of the formatting style.

Can checkboxes use values other than TRUE and FALSE?

Yes. Google Sheets lets you assign custom checked and unchecked values through Data validation.

Why is the row below my checkbox changing instead?

The formula row and the first row of the apply range may not match. Check both the conditional-formatting range and the row number in the formula.

FINAL TAKEAWAY

One checkbox can make a task tracker much easier to scan

Add a checkbox for each task, use its TRUE value as a conditional-formatting trigger, and let Google Sheets automatically change the row when the task is finished. You can use color, strikethrough, or both to keep completed work visually separate from what still needs attention.

SOURCES AND LAST CHECKED

This guide is based on current Google Sheets Editors Help documentation for checkboxes, custom checkbox values, and conditional formatting with custom formulas. Last checked: October 2026.