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

Google Sheets tutorials›Formatting›Create conditional formatting

Google Sheets · Verified tutorial

Create conditional formatting in Google Sheets

Add conditional formatting to B2:B5 with the custom formula =B2>200. Choose any visible fill color for matching cells.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Add conditional formatting to B2:B5 with the custom formula =B2>200. Choose any visible fill color for matching cells.

Step-by-step

1

Select the targetAdd conditional formatting to B2:B5 with the custom formula =B2>200.

2

Apply the changeChoose any visible fill color for matching cells.

Shortcut or faster method

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

Expected result

B2:B5 has a custom conditional-formatting rule for amounts over 200.

Common mistake

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

Troubleshooting

Re-select B2:B5 and repeat the final action. B2:B5 has a custom conditional-formatting rule for amounts over 200.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
Hosting	80
Software	120
Ads	300
Design	500

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Add conditional formatting to B2:B5 with the custom formula =B2>200.
Apply the change. Choose any visible fill color for matching cells.
B2:B5 has a custom conditional-formatting rule for amounts over 200.