Google Sheets Checkbox Color: What You Can Change

Google Sheets does not provide a separate color picker for the checkbox control itself. To make a checked box stand out, use Format > Conditional formatting to change the checkbox cell’s background or text formatting when its value is TRUE; you can also color an entire row based on the checkbox.

What checkbox color settings Google Sheets offers

A checkbox in Sheets is a value displayed as a clickable control inside a cell, rather than a small drawing with its own independent design settings. The standard control does not have a dedicated menu for choosing its outline, tick, or fill color. This is why selecting a checkbox and looking for a color option for the control itself will not reveal one.

You can still use color to communicate its state. Conditional formatting can apply a cell background and text formatting when the checkbox is checked or unchecked. Depending on how the checkbox is rendered, text-color formatting may also affect how its mark appears, but it is not an independent checkbox-color setting. The dependable way to make the state visually obvious is to format the cell or the surrounding row.

To add a checkbox, select a cell or range and choose Insert > Checkbox. By default, a checked box has the value TRUE and an unchecked box has the value FALSE. Those values make it possible to create formatting rules that respond automatically as people click the boxes.

Change a checkbox cell’s color when it is checked

For a simple checklist in A2:A20, you can make each checked cell stand out with a conditional-formatting rule. The rule should cover the checkbox cells, and its condition should refer to the checkbox value. Set it up this way:

Select A2:A20, or select the checkbox range you want to format.
Choose Format > Conditional formatting. A conditional-formatting panel opens.
Confirm that the “Apply to range” field contains your checkbox range.
Under “Format cells if,” choose the option for a custom formula.
With checkboxes in A2:A20, enter =A2=TRUE. A2 is the first cell in the selected range, so the rule adjusts for the other cells.
Under “Formatting style,” choose a fill color, text color, or other available style, then select Done.

When A2 is checked, its value is TRUE and the rule applies; when it is unchecked, the condition is false and the conditional style is removed. Choose a color that remains easy to read with the checkbox visible. For example, a pale green background can indicate completed tasks while keeping the check control distinct from the fill.

If you prefer not to use a formula, the conditional-formatting options may let you set the condition to “Is equal to” and enter TRUE. The custom-formula method is especially useful when you later want to format other cells based on the checkbox.

Color an entire row from one checkbox

In a task list, coloring only the checkbox cell may be easy to miss. You can instead shade the task’s entire row when its checkbox is checked. Suppose the checkboxes are in A2:A20 and task details occupy columns B through F. Select A2:F20, open Format > Conditional formatting, and set the rule to use a custom formula.

With checkboxes in A2:A20 and the selected rows running from row 2 through row 20, use =$A2=TRUE. The dollar sign fixes the checkbox column as the rule is applied across each row, while the row number can adjust for each row. Choose a restrained fill color, then select Done. Checking A4, for example, applies the style across A4:F4, not to every row.

The range and formula need to line up. If your first selected row is row 5, the formula should refer to row 5; if the checkbox is in column C, lock column C instead. A common setup error is using a formula that points to the wrong row or checkbox column, which can make formatting appear one row off or follow a different checkbox.

What changes with custom checkbox values

Sheets can use custom values instead of TRUE and FALSE for checkbox cells. This is useful when a connected workflow expects values such as “Done” and “Pending,” but it changes what your conditional-formatting rule must test. To review or set the values, select the relevant cells and open Data > Data validation. In the checkbox criteria, use the option for custom cell values and set the checked and unchecked values you need.

If a checked box now stores the text Done, a rule that checks for TRUE will no longer match. For a checkbox in A2, the corresponding custom-formula condition is =A2="Done". Make the text in the rule exactly match the checked value, including spaces and capitalization where relevant. If you do not need custom values, the default TRUE and FALSE values are usually simpler for formulas, filters, and conditional formatting.

Changing checkbox values can also affect other parts of a sheet. For example, a formula or connected process that expects TRUE may not behave as intended when the cell contains the word Done. Before changing existing checkbox criteria, check whether formulas, filters, or integrations rely on the current values.

Common problems and how to fix them

The color does not change when you click: Check that the conditional rule covers the checkbox cell and tests the value actually stored there. A rule for TRUE will not match a custom checked value such as Done.
The wrong row changes color: Make the formula’s row reference match the first row in “Apply to range.” For full-row formatting, lock the checkbox column, as in =$A2=TRUE, but leave the row number relative.
Every row gets the same formatting: Check whether the formula accidentally locks the row number, or whether the rule refers to one fixed checkbox cell. A reference such as =$A$2=TRUE always checks A2, so it is generally not suitable for testing a different checkbox on every row.
The checkbox looks unchanged: Conditional formatting changes cell styling, not a separately configurable checkbox graphic. Check whether the cell background changed; do not assume that the checkbox control has an independent color setting.
Two styles compete: Open the conditional-formatting panel and review the rules that apply to the same range. Overlapping rules can make it unclear which style is responsible for the visible result. Narrow the ranges or simplify the conditions.

When troubleshooting, first click the checkbox and inspect the value or the rule’s condition. Then check the applied range, the first-row reference, and any custom checkbox values. These checks usually identify whether the problem is the rule, the range, or an expectation that Sheets offers a separate control-color feature.

Conditional formatting versus manual color

Manual formatting is appropriate when you want a cell to have a fixed appearance regardless of whether it is checked. Select the cell and use the fill-color or text-color controls in the toolbar. This style does not automatically respond to clicks, so it can become misleading if users assume that a colored cell means the task is complete.

Conditional formatting is better when color should communicate status. It updates as the checkbox value changes, keeps the meaning consistent, and can be applied to a whole range or row. It does require a correctly configured rule, and it formats cells rather than giving the checkbox a separate custom design. If you only need a clear completed-versus-open signal, a conditional background is usually the most practical approach.

For a small personal checklist, manual color may be enough. For a shared task tracker, conditional formatting is generally safer because the status color follows the checkbox instead of relying on someone to recolor cells by hand. Use a short legend or a clear column heading if the sheet contains several status colors.

Readability and alternatives

Color should reinforce the checkbox, not be the only indication of status. Some readers may have difficulty distinguishing certain colors, and a printed sheet may lose color altogether. Keep the checkbox visible, use readable contrast, and consider adding a status label or a separate text description when the distinction matters. Avoid using a strong red-versus-green contrast as the only signal in a shared workflow.

If the goal is to show progress rather than decorate a checkbox, alternatives include a status column, a label such as Done or In progress, or a progress summary elsewhere in the sheet. A separate label can be useful in reports or printed views, while a checkbox is convenient for quick input. You can also combine the two: users click a checkbox, and conditional formatting shades the row while a formula or other sheet logic presents a readable status. Choose the arrangement that makes the sheet understandable to people who did not build it.

Frequently Asked Questions

Can I change only the checkbox tick to red or blue?
Google Sheets does not provide a dedicated setting for coloring only the checkbox mark. Conditional formatting can style the cell, and text formatting may affect how the control is rendered, but the checkbox itself is not an independently styled object.

Can the checkbox cell turn green when checked?
Yes. Apply conditional formatting to the checkbox range and set a rule for its checked value, usually TRUE for default checkboxes. Choose a green fill in the formatting style; the cell changes automatically as its value changes.

Can I color the whole row when a box is checked?
Yes. Apply a conditional-formatting rule to the row range and use a custom formula that refers to the checkbox column, such as =$A2=TRUE when the checkbox is in A2 and the first selected row is row 2.

Why does my rule stop working after I change checkbox settings?
The rule may still be looking for TRUE while the checkbox now stores a custom value such as Done. Update the condition to match the new checked value, and check any other formulas that use the checkbox cells.

Does this work in Excel too?
Excel has its own checkbox features and conditional-formatting behavior, which differ by version and checkbox type. The menu paths and steps here are for Google Sheets in a web browser; do not assume that Sheets instructions apply directly in Excel.

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.