New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Data validation›Conditionally format checkboxes

Google Sheets · Verified tutorial

Conditionally format checkboxes in Google Sheets

Add conditional formatting to A2:B5 with the custom formula =$B2=TRUE. Choose any visible fill color for matching rows.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

Add conditional formatting to A2:B5 with the custom formula =$B2=TRUE. Choose any visible fill color for matching rows.

Step-by-step

1

Select the targetAdd conditional formatting to A2:B5 with the custom formula =$B2=TRUE.

2

Apply the changeChoose any visible fill color for matching rows.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

A2:B5 has a custom conditional-formatting rule driven by the checked boxes.

Common mistake

Typing the formula as plain text or placing it in the wrong cell.

Troubleshooting

Re-select A2:B5 and repeat the final action. A2:B5 has a custom conditional-formatting rule driven by the checked boxes.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Done
Draft brief	true
Review copy	false
Publish page	true
Send report	false

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Add conditional formatting to A2:B5 with the custom formula =$B2=TRUE.
Apply the change. Choose any visible fill color for matching rows.
A2:B5 has a custom conditional-formatting rule driven by the checked boxes.