How to Make a Checkbox Green in Google Sheets When Checked

To make a Google Sheets checkbox cell turn green when checked, select the checkbox range, open Format > Conditional formatting, and add a rule that formats cells when a custom formula is true: =A2=TRUE. Choose a green fill and click Done. This changes the cell background, not the checkbox tick itself; Sheets does not provide a separate setting for changing the checkbox icon’s color.

What You’ll Need

A Google account and a spreadsheet open in Google Sheets in a web browser.
A range containing checkboxes. For a new range, select the cells and choose Insert > Checkbox first.
The cell address of the first checkbox in your selected range, so the conditional-formatting formula can refer to the right cell.

Step-by-Step

Check that your cells contain checkboxes. Click a checkbox cell and verify that clicking it switches between checked and unchecked. If you need to add checkboxes, select the cells where they should appear, then choose Insert > Checkbox. For example, a task list might have labels in column A and checkboxes in B2:B50. The instructions below use that checkbox range as an example. Your actual range can be in any column.
Select the checkbox cells you want to format. For the example, select B2:B50 by clicking the name box above the sheet, typing B2:B50, and pressing Enter, or drag over the cells. Include only the cells whose backgrounds you want controlled by their checkboxes. If you have a header in B1, leave it out so it does not get formatted as part of the list.
Open the conditional-formatting panel. In the menu, choose Format > Conditional formatting. A Conditional format rules panel opens on the right. Check the Apply to range field and make sure it shows the cells you selected, such as B2:B50. You can edit the field directly if the selection is incomplete or includes extra cells.
Set the rule to check the checkbox value. Under Format rules, open the formatting-condition menu and choose Custom formula is. In the formula field, enter =B2=TRUE when B2 is the first cell in the applied range. The row number in the formula must match the first row of that range. For a range starting at B2, do not use B1 or B3. Google Sheets checkboxes normally return TRUE when checked and FALSE when unchecked, so the rule becomes active only for checked cells.
Choose a green appearance. In Formatting style, click the fill-color button, usually shown as a paint bucket, and choose a green shade. Pick a fill that leaves the checkbox easy to see. If the labels or other text in these cells need more contrast, you can also choose a suitable text color, but the fill is what makes the cell background green.
Apply the rule. Click Done at the bottom of the Conditional format rules panel. Click one of the checkboxes in the selected range. The cell should turn green when checked. Click it again to clear the check: the green fill should disappear because the formula is no longer true. Sheets saves changes automatically, so there is no separate save command.
Extend the rule if the list grows. If you expect more checkboxes, reopen Format > Conditional formatting and change Apply to range to a larger range, such as B2:B200. Keep the formula based on the first cell, =B2=TRUE. Sheets adjusts the row reference as it evaluates each cell in the range, so each checkbox can control its own background.

If your checkbox is in a different column, replace B with that column’s letter. For example, if the first checkbox is in D5 and the rule applies to D5:D80, use =D5=TRUE. The first cell reference is relative, which is important: it lets the rule test D5 for the first row, D6 for the next row, and so on. Avoid adding a dollar sign before the row number for a range of individual checkbox cells, because that would make every row test the same checkbox.

You can also color an entire task row instead of only the checkbox cell. Suppose checkboxes are in column B and task details run from A2 through D50. Set Apply to range to A2:D50 and use =$B2=TRUE. The dollar sign fixes the checkbox column as B, while the row number changes for each row. Choose a green fill, and checking the box in B2 will color A2:D2; checking B3 will color A3:D3. This is useful when a completed task should stand out across its full row.

Common Mistakes

Using the wrong starting cell in the formula. If your applied range begins at B2 but the formula refers to B1, every row is evaluated against the wrong cell. Make the reference match the top-left cell of the range, unless you are intentionally using an anchored reference to color full rows.
Expecting the checkmark itself to change color. Conditional formatting changes cell properties such as fill and text color. It does not recolor the built-in checkbox icon independently. A green cell background is the standard way to make a checked item look green in Sheets.
Formatting the wrong range. A rule for B2:B50 will not affect a checkbox in B51. Conversely, including a heading or notes column may color cells that are not meant to respond to the checkbox. Review Apply to range before choosing Done.
Typing a text value instead of a Boolean value. Standard checkboxes return TRUE or FALSE as Boolean values. A formula that checks for the word Checked will not match a standard checkbox unless you have deliberately configured custom checkbox values.
Using a fixed row reference by mistake. A formula such as =$B$2=TRUE locks both the column and row. Applied to many rows, it makes every row depend on B2. For full-row formatting, lock only the column with =$B2=TRUE.

Tips

Choose a pale green for busy sheets. A light fill helps text remain readable and makes the checkbox visible. Very dark fills can make the cell feel heavy, especially in a long checklist. You can adjust the shade later by reopening the conditional-formatting rule.
Use the same rule for a consistent checklist. Apply one rule to the full checkbox range rather than creating a separate rule for each cell. A single relative formula is easier to expand and less likely to contain inconsistent references.
Color task details as well as the box. Use a whole-row range and an anchored checkbox-column reference, as described above, if people need to scan completed task names. Keep the range limited to the table so unrelated columns are not affected.
Put the checkbox in a predictable column. If a sheet has several checkbox columns, create a separate rule for each one. This makes it clear which checkbox controls which cells and avoids applying a rule across unrelated lists.
Remember that conditional formatting is dynamic. You do not have to manually remove the green fill when someone unchecks a box. The rule recalculates as the value changes and displays the normal cell format when its condition is false.
Do not confuse Google Sheets and Excel instructions. These menu paths and checkbox behavior are for Google Sheets in a browser. Excel has different checkbox and conditional-formatting workflows, so its instructions should not be followed step for step here.

Troubleshooting

The cell does not turn green when checked. Reopen Format > Conditional formatting and confirm the rule is enabled, the applied range includes the checkbox cell, and the formula refers to the first cell in that range. For example, a range of C3:C40 should start with =C3=TRUE. Click Done after making edits, then toggle a checkbox to refresh the displayed result.

The wrong row turns green. Check whether the formula’s row number matches the first row of Apply to range. If the rule covers whole rows A2:D40 and the checkboxes are in B, use =$B2=TRUE. If the rule instead covers individual cells B2:B40, use =B2=TRUE. A misplaced dollar sign can hold the reference still when you need it to move.

The cell stays green after you uncheck the box. Look for another conditional-formatting rule that also applies to the cell. The Conditional format rules panel lists rules for the current selection; overlapping rules can make a fill appear to remain. Edit or remove the conflicting rule, or inspect its condition and formatting style. Also check whether the cell has a manually applied green fill; a regular fill may show when the conditional rule is no longer active.

The formula does not recognize a custom checkbox. If the checkbox was set up with custom checked and unchecked values rather than the default TRUE and FALSE, inspect its data-validation settings and write the conditional rule to match the checked value. For example, a checkbox configured to return the word Yes needs a condition that tests for Yes, not TRUE. Standard checkboxes do not need this adjustment.

The checkbox is missing or cannot be clicked. Confirm that you are editing the intended sheet and that the cell is not protected in a way that prevents editing. If there is no checkbox in the cell, select the target range and choose Insert > Checkbox. If conditional formatting still looks unchanged, close the rule panel, click the checkbox again, and confirm that the value changes.

Frequently Asked Questions

Can I make only the checkbox tick green?
No. Google Sheets conditional formatting can change the cell’s fill and text styling, but it does not expose a separate color control for the checkbox icon. Use a green cell fill to signal that it is checked.

Does this work when I check multiple boxes?
Yes. Apply the rule to the full checkbox range and use a relative reference based on its first cell. Each checkbox is evaluated separately, so checking several boxes turns each corresponding cell green.

Can the whole row turn green when I check a box?
Yes. Apply the rule to the row area, such as A2:D50, and use a formula such as =$B2=TRUE when the checkbox is in column B. The row reference changes as the rule checks each row.

Will the green fill remain if I copy the checkbox?
When you copy a cell that includes its formatting, the conditional-formatting rule may also be copied or the destination may be covered by an existing rule. Check Apply to range afterward and extend it to cover any new checkbox cells.

Can I use a different color for unchecked boxes?
Yes. Add a second conditional-formatting rule for the unchecked state and choose another fill. For a standard checkbox range beginning at B2, a custom formula such as =B2=FALSE matches unchecked boxes. Check both rules’ ranges if their formatting appears to conflict.

Will the same steps work in Excel?
No. The guide uses Google Sheets menu paths and checkbox values. Excel has its own checkbox options and formatting behavior, so use instructions written specifically for your Excel version.

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.