Highlight an entire row with conditional formatting in Google Sheets
Highlight entire rows in A2:B5 when Amount exceeds 200 by using the custom formula =$B2>200. Choose any visible fill color.
Verified by JosephineAbout 60 secondsHighlight entire rows in A2:B5 when Amount exceeds 200 by using the custom formula =$B2>200. Choose any visible fill color.
Step-by-step
Select the targetHighlight entire rows in A2:B5 when Amount exceeds 200 by.
Complete the next actionthe custom formula =$B2>200.
Apply the changeChoose 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
A2:B5 has a row-highlighting 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 a row-highlighting custom-formula rule.
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. Highlight entire rows in A2:B5 when Amount exceeds 200 by.
- Complete the next action. the custom formula =$B2>200.
- Apply the change. Choose any visible fill color.
- A2:B5 has a row-highlighting custom-formula rule.