Conditional formatting not working in Google Sheets
Add a custom-formula conditional formatting rule to B2:B4 using exactly =B2>100. Choose any visible fill color for matching cells.
Verified by JosephineAbout 75 secondsAdd a custom-formula conditional formatting rule to B2:B4 using exactly =B2>100. Choose any visible fill color for matching cells.
Step-by-step
Select the targetAdd a custom-formula conditional formatting rule to B2:B4.
Complete the next actionexactly =B2>100.
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:B4 has a custom conditional formatting rule driven by =B2>100.
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. B2:B4 has a custom conditional formatting rule driven by =B2>100.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Item | Amount |
| Hosting | 80 |
| Software | 120 |
| Design | 500 |
Video transcript
- Open the prepared Formatting repair spreadsheet.
- Select the target. Add a custom-formula conditional formatting rule to B2:B4.
- Complete the next action. exactly =B2>100.
- Apply the change. Choose any visible fill color for matching cells.
- B2:B4 has a custom conditional formatting rule driven by =B2>100.