📋 GS Color Scale Formatting Guide

Feature: Color Scale Formatting (under Conditional Formatting)

Navigation: Format → Conditional formatting → Color scale

This formatting does not require a formula; instead, it uses minimum, midpoint, and maximum values to apply gradient colors across a selected range.

 
Applies gradient colors to a cell range based on the relative value of each cell, creating a visual heatmap.
    

You manage a list of monthly sales and want to quickly visualize which months performed best and worst. Color scale formatting automatically applies a gradient—e.g., red for low, yellow for medium, green for high—making trends instantly visible.

Suppose you have monthly revenue data in B2:B13:

Month   | Revenue
--------|---------
Jan     | 5000
Feb     | 7000
Mar     | 10000
Apr     | 6500
May     | 12000
...     | ...

Steps to Apply:

1. Select range B2:B13
2. Go to Format → Conditional formatting
3. Choose the “Color scale” tab
4. Set minimum (red), midpoint (yellow), maximum (green)
5. Click “Done”

Result: Cells with higher revenue turn green, middle values yellow, and lower revenues red — forming a heatmap.

• Creating heatmaps for test scores or KPIs
• Visualizing sales performance by product or region
• Tracking temperature, humidity, or climate data
• Highlighting expense levels in financial records
• Color-coding time durations or completion percentages

• Uniform colors: Occurs when data has little variation. Fix: Add more diverse values or adjust scale settings manually.
• Wrong range selected: Applies color to incorrect data. Fix: Confirm the “Apply to range” section is correct.
• Color scale not visible: If your theme or text formatting hides the effect. Fix: Reset cell formatting or adjust contrast.

🧠 7. Bonus Tips

🗂️ 8. Navigation