Cell Value Heatmap

Cell Value Heatmap colors the background of numeric cells on a gradient, so high and low values stand out at a glance.

How to use Cell Value Heatmap#

1. Select the cells on your sheet

The tool uses your current selection. Text cells are ignored, and only numeric cells are colored.

2. Open the tool

Open the sidebar from Extensions > Text To Table Converter > ⚡ Launch Sidebar. On the home screen, under Sheets tools, choose Sheets Mega Tools, then choose Cell Value Heatmap.

You can also use Extensions > Text To Table Converter > Sheets Mega Tools to open the Sheets Mega Tools screen directly.

3. Choose a color scheme

The schemes are always visible in the panel:

• Green -> Yellow -> Red (default)
• Blue -> White -> Red
• Custom

4. Pick colors for Custom (optional)

The Min color and Max color pickers are available only when Custom is selected. Colors blend smoothly between your two choices.

5. Click Execute

The heatmap is applied to the background of the numeric cells.

How it works#

• The lowest number gets the first color and the highest number gets the last color. Numbers in between get a blend.
• Only background color changes. Text color stays the same.
• Text, errors, and empty cells are left unchanged.
• The tool handles up to 50,000 numeric cells at a time. A larger selection stops with "Heatmap supports up to 50,000 numeric cells at a time." No warning appears first.
• If the selection has no numbers, you get "No numeric values found in the selection."

Color schemes#

• Green -> Yellow -> Red: the lowest value is green, the middle is yellow, and the highest value is red.
• Blue -> White -> Red: the lowest value is blue, the middle is white, and the highest value is red.
• Custom: your Min color for the lowest value and Max color for the highest.

Example#

For the values 10, 25, 50, 75, 100 with Green -> Yellow -> Red:

• 10 (lowest): green
• 25: green-yellow blend
• 50: yellow-ish
• 75: yellow-red blend
• 100 (highest): red

Use Cases#

• Compare metrics across teams or time periods
• Spot high and low values in financial data
• Find outliers in test or survey data
• See which products or regions sell best