Format
Google Sheets: Format
Categories:
Apply conditional format with specific cell
Use the Custom formula is to specify the specific cell, and =cell absolute position (=$B$3). Then compare to the current cell relative from the Apply to range
| Field | Setting |
|---|---|
| Apply to range | D2:D1000 |
| Format rules | =$B$3 > D2 |
Reference
- Google Sheets Conditional Formatting Based on Another Cell
- Google Sheets - Conditional Formatting Based on Another Cell - YouTube
- Use conditional formatting rules in Google Sheets - Computer - Google Docs Editors Help
- How-To: Conditional Formatting Based on Another Cell in Google Sheets