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

Google Sheets tutorials›Errors›Conditional formatting applies to wrong cells

Google Sheets · Verified tutorial

Conditional formatting applies to wrong cells in Google Sheets

Replace the incorrect conditional formatting with one custom-formula rule on B2:B4 using exactly =B2>100. Use any visible fill color.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

Replace the incorrect conditional formatting with one custom-formula rule on B2:B4 using exactly =B2>100. Use any visible fill color.

Step-by-step

1

Select the targetReplace the incorrect conditional formatting with one custom-formula rule on B2:B4.

2

Complete the next actionexactly =B2>100.

3

Apply the changeUse any visible fill color.

Shortcut or faster method

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

Expected result

The requested rule applies to B2:B4.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select B2:B4 and repeat the final action. The requested rule applies to B2:B4.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Amount
Hosting	80
Software	120
Design	300

Video transcript

Open the prepared Formatting recovery spreadsheet.
Select the target. Replace the incorrect conditional formatting with one custom-formula rule on B2:B4.
Complete the next action. exactly =B2>100.
Apply the change. Use any visible fill color.
The requested rule applies to B2:B4.