How to Add Color to Checkboxes in Google Sheets Easily

To add color to checkboxes in Google Sheets, select the checkbox cells and use the toolbar’s text color for a simple visual change, or set up conditional formatting to color cells automatically when boxes are checked. Google Sheets does not offer a separate color picker for the checkbox control itself, so conditional formatting is the most reliable way to make a checked item stand out.

What You’ll Need

A Google Sheet opened in a web browser with permission to edit it.
A range containing checkboxes. If you have not added them yet, you can insert them during the first step.
For automatic color changes, the standard checkbox values TRUE and FALSE. These are set by default when you insert checkboxes.

The steps below use Google Sheets in a browser. Excel has its own checkbox and conditional-formatting menus, so its instructions are different.

Step-by-Step

Select or create the checkbox range. Click the first cell where you want a checkbox, then drag across the cells that should contain checkboxes. To add them, choose Insert > Checkbox. Sheets places an unchecked box in each selected cell. If checkboxes already exist, select those cells instead. For example, if your task list runs from A2 to A20, select A2:A20 before making changes. Be aware that inserting checkboxes into cells replaces their existing contents.
Try changing the checkbox text color. With the checkbox cells selected, click the Text color button in the toolbar (the underlined A) and choose a color. This can tint the visible checkbox mark in Sheets views that apply text formatting to it. It does not provide a separate setting for the checkbox outline, and the exact appearance can vary by browser or display. If the mark does not change, use the cell-fill method or conditional formatting below.
Apply a background color manually, if that is enough. Keep the range selected, open the toolbar’s Fill color button (the paint-bucket icon), and choose a background color. This colors the cells behind the checkboxes whether they are checked or unchecked. It is useful for marking an entire checklist section, but it will not react when someone clicks a box. To color only checked items, continue with conditional formatting.
Open conditional formatting for the selected range. Select the checkbox range again if needed, then choose Format > Conditional formatting. A conditional-formatting panel opens on the right. Check the Apply to range field to make sure it contains the correct cells, such as A2:A20. The rule’s formula will refer to the top-left cell in this range, so select the first checkbox cell as the reference.
Make a rule for checked boxes. In the panel, open Format cells if and choose Custom formula is. For a range beginning at A2, enter =A2=TRUE. This asks Sheets to apply the style when the checkbox in each row is checked. Choose a text color and/or a fill color in the formatting style controls. For a clear result, try a pale green fill and a darker green text color. Click Done to save the rule.
Check that the reference matches your range. In the example, A2 is the first cell in A2:A20, so the formula starts with A2. Sheets adjusts that reference for each row: it evaluates A3 for the next checkbox, then A4, and so on. If your range instead begins at C5, use =C5=TRUE. Avoid adding dollar signs to the row reference when you want each row to be checked separately.
Add a different style for unchecked boxes, if useful. In the conditional-formatting panel, click Add another rule, keep the same apply-to range, and choose Custom formula is again. For a range starting at A2, enter =A2=FALSE. Choose a subtle style, such as gray text or a light-gray fill, then click Done. You now have one rule for checked boxes and another for unchecked boxes. You can omit this second rule if unchecked cells should keep their normal appearance.
Test the result and adjust the colors. Click a checkbox to check it, then click it again to uncheck it. The checked rule should appear and disappear as the value changes. If you cannot easily see the result, reopen Format > Conditional formatting and choose more contrasting colors. Keep the cell content and the checkbox visible; very dark fills or low-contrast text can make a list harder to use.

These rules color the cell’s formatting when the checkbox value changes. A fill color is generally the most dependable visual signal; text color may affect the mark in some Sheets views but is not a dedicated checkbox-color control. You can use both if the combination looks clear in your sheet.

Common Mistakes

Using the wrong starting cell in the custom formula. The formula should refer to the first cell in the apply-to range. If the range is B3:B15, a rule starting with =A2=TRUE checks the wrong cells. Change the reference to B3.
Entering a formula for a different kind of checkbox value. Standard checkboxes evaluate to TRUE or FALSE. If you configured custom checked and unchecked values, the TRUE/FALSE rules will not match those values. Use a formula that compares the first cell with the custom checked value instead, such as =A2="Done" if the checked value is Done.
Expecting the outline itself to change color. Conditional formatting changes cell text or fill formatting; it does not offer a separate control for the checkbox border. Use a cell fill, a text color where it is visibly applied, or a colored cell elsewhere in the row to provide a reliable status cue.
Applying a static fill and expecting it to update. The toolbar’s Fill color button colors the selected cells immediately but does not depend on checkbox state. Use a conditional-formatting rule if the color should switch as people check and uncheck boxes.
Selecting too much or too little. A rule applied only to A2 will not color the rest of a checklist. Conversely, a rule applied to an entire column can unintentionally format unrelated cells. Set the apply-to range to the actual checkbox cells or the specific row range you want styled.

Tips

Color a whole task row instead of just the checkbox cell. If checkboxes are in column A and task descriptions are in B through D, set the apply-to range to B2:D20 and use the formula =$A2=TRUE. The dollar sign fixes the checkbox column while allowing the row number to adjust. You can include column A in the apply-to range too if you want the checkbox cell’s background colored with the row.
Use restrained colors for long lists. A light fill with dark text usually preserves readability better than a saturated background. Choose colors that remain distinguishable if viewed on a low-quality display, and do not rely on color alone to communicate an important status.
Keep the rules easy to maintain. A single checked rule is enough for many lists. Add an unchecked rule only if it helps people tell incomplete work from unmarked or unused rows. Clear labels, such as a task name and a status heading, make the visual formatting more meaningful.
Copy the formatting carefully. When you extend a checklist, verify that the new cells are included in the rule’s apply-to range. You can inspect existing rules by selecting a cell in the range and opening Format > Conditional formatting. Review the range and formula before duplicating or adding more rules.

Troubleshooting

Nothing changes when you check a box. Open the conditional-formatting panel and confirm that the rule applies to the cell you are clicking. Then check that the formula references the first cell in that range and tests the correct value. For a standard checkbox in A2, =A2=TRUE should match a checked box. If the checkbox uses a custom value, replace TRUE with that value.

The color appears on the wrong row. Look at both the apply-to range and the formula reference. If your range starts at A2 but the formula starts at A1, Sheets evaluates a neighboring row instead. Make the formula’s initial cell the top-left cell of the range. If you are coloring whole rows based on column A, use an absolute column reference, as in =$A2=TRUE, so the condition stays tied to column A across the row.

The checkbox mark stays the same color. That can happen because Google Sheets does not expose an independent checkbox-color setting. Use a conditional fill on the checkbox cell or the task row for a dependable state-based color change. If you are using toolbar text color, confirm that the text-color change is visible in your current browser, but do not rely on it as the only signal.

The color never goes away after unchecking. A manually applied fill may still be present beneath the conditional format, or another conditional-formatting rule may also be setting a fill. Remove the static fill if you want the cell to return to its default appearance, and review other rules for overlapping ranges. Rules can coexist, so simplify them if their results are confusing.

The cells show TRUE or FALSE instead of boxes. Those are the checkbox values, but the cells may not currently have checkbox validation. Select the relevant cells and choose Insert > Checkbox. If the cells had important contents before inserting checkboxes, undo immediately if possible or restore those contents from a version history or backup.

Frequently Asked Questions

Can I change only the checkbox checkmark color?

Google Sheets does not provide a dedicated setting just for the checkmark or checkbox outline. You can try the toolbar’s text color, but the most dependable option is to color the cell or its row with conditional formatting.

Can a checkbox change color automatically when it is clicked?

Yes. Add a conditional-formatting rule for the checkbox range, use a custom formula such as =A2=TRUE for a range starting at A2, and choose a fill or text style. The formatting updates when the checkbox value changes.

How do I color the whole row when a box is checked?

Set the apply-to range to the task columns, for example B2:D20, and use =$A2=TRUE if the checkboxes are in A2:A20. The fixed column reference keeps the test in column A as Sheets formats cells across each row.

Why does my custom checkbox rule not work?

Custom checkbox settings can use values other than TRUE and FALSE. Check the cell’s configured checked value, then compare against it in the conditional-formatting formula. For example, if the checked value is Done, use =A2="Done" when A2 is the first cell in the range.

Will the checkbox color look the same on every device?

Cell fill colors are generally more consistent than changes to the checkbox mark itself. Browser rendering and screen settings can vary, so use a readable fill and text contrast, then check the sheet on the devices your collaborators use when appearance matters.

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.