Google Sheets · Verified tutorial
Verified by JosephineAbout 60 seconds
Use a custom formula in conditional formatting in Google Sheets
Add conditional formatting to A2:B5 with the custom formula =$B2="Done". Choose any visible fill color for matching rows.
Verified by JosephineAbout 60 secondsQuick answer
Add conditional formatting to A2:B5 with the custom formula =$B2="Done". 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="Done".
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 the requested custom-formula rule.
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 the requested custom-formula rule.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Task | Status |
| Draft brief | Open |
| Review copy | Done |
| Publish page | Open |
| Send report | Done |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Add conditional formatting to A2:B5 with the custom formula =$B2="Done".
- Apply the change. Choose any visible fill color for matching rows.
- A2:B5 has the requested custom-formula rule.