In this article:

How to Create a Heat Map in Google Sheets (2024 Update)

May 8, 2024

How to Create a Heat Map in Google Sheets

Follow the steps below to easily create a heat map in Google Sheets.

Step 1: Prepare Your Data

First, open a new Google Sheets document. Enter your data in a table format. For example, you could have a list of products in column A and their corresponding sales numbers in column B.

google sheets heat map

Step 2: Select Your Data

Click and drag to highlight the cells containing your data. In our example, it would be the sales numbers (Column B, excluding the header).

heat map google sheets

Step 3: Apply Conditional Formatting

Go to the menu and click on Format. Select Conditional formatting from the dropdown menu.

heat map in google sheets

Step 4: Set Up the Heat Map

A panel will open on the right side of your screen. Select “Color scale”. Below that, you'll see three color buckets. 

Here's how to set it up: 

Minpoint: Choose "Percent" and enter 0%, then select a light color. In our example, we choose red.

Midpoint: Choose "Percent" and enter 50%, then select a middle color.

Maxpoint: Choose "Percent" and enter 100%, then select a dark color.

creating a heat map in google sheets

You can also select from any of the default color scales to represent your heat map. 

how to create a heat map in google sheets

Step 5: Apply and Review

Click “Done” after setting up your color scale. Your data should now be displayed as a heat map, with colors representing different data values.

how to make a heat map in google sheets

We hope that this article has helped you and given you a better understanding of how to make a heat map in Google Sheets. If you enjoyed this article, you might also like our articles on how to change the default font in Google Sheets and how to fix circular dependency detected in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->