📋 GS Single Color Formatting Guide

Feature: Single Color Formatting (part of Conditional Formatting)

Navigation: Format → Conditional formatting → Single color

Optional Formula Rule Syntax:

=A1>50

or

=ISBLANK(A1)

 
Applies one consistent color format to cells that meet a specified condition or rule.
    

You want to highlight all students who scored above 90 in green, to easily identify top performers. With “Single Color” formatting, you can color only those cells that meet your condition without affecting the rest.

Suppose you have this data in range B2:B6:

Name    | Score
--------|-------
Alice   | 85
Bob     | 95
Charlie | 78
David   | 91
Eve     | 67

Steps:

1. Select range B2:B6
2. Go to Format → Conditional formatting
3. In “Single color” tab, under Format cells if: choose Greater than → enter 90
4. Choose a green fill
5. Click “Done”

Result: Bob and David’s scores are highlighted in green.

• Highlight top-selling products by revenue.
• Mark employees who exceeded targets.
• Show expenses above budget limits.
• Flag completed vs. pending tasks.
• Color overdue dates in a deadline tracker.

• Wrong cells highlighted: Often caused by incorrect relative references. Fix: Use =$B2>90 if working across a row.
• Formatting not visible: Cell format might already have a manual color. Fix: Clear formatting first.
• Formula mismatch: E.g., using =B2>90 on a range that starts from B3. Fix: Match the cell references exactly.

🧠 7. Bonus Tips

🗂️ 8. Navigation