Excel

How to Create a Heat Map in Excel

Create an Excel heat map with conditional formatting to spot high and low values across schedules, budgets, sales, and operating trackers.

Do this with AI

Try Griddy free

Start in your browser. Also works with Excel and Google Sheets.

By Justin Freels/Updated August 20, 2026/4 min read

An Excel heat map uses color to show relative size, risk, frequency, or intensity across a grid. It is useful when you need to scan many numbers quickly: hourly sales, staffing coverage, campaign performance, budget variance, or project risk.

Use a heat map when the pattern matters more than the exact value in every cell.

Create a basic heat map

Step 1. Arrange the data in a clean grid.

Step 2. Select the numeric cells only.

Step 3. Choose Home -> Conditional Formatting -> Color Scales.

Step 4. Pick a scale that matches the meaning of the data.

Step 5. Use Manage Rules if you need custom minimum, midpoint, or maximum settings.

For risk and variance, red can mean high attention. For sales or completion, darker green may mean better performance. The color meaning should be obvious to the person reading the sheet.

Example: find restaurant staffing pressure

Suppose a restaurant tracks expected guest volume by day and hour. Put days across the columns and time blocks down the rows, then apply a heat map to the volume forecast.

The darker cells show the service windows that need more coverage. Managers can compare the pattern against an employee schedule for restaurants and decide whether lunch, dinner, weekend, or closing shifts need adjustment.

The same idea works for an expense tracker for restaurants if you want to highlight high spending by category and week.

Choose the right color scale

Use two colors when the question is high versus low. Use three colors when the middle matters, such as negative variance, near plan, and positive variance.

Avoid decorative color scales. If the colors do not help someone make a decision faster, the heat map is just noise.

Common heat map mistakes

Mistake	What happens	Fix
Selecting totals with detail cells	Totals dominate the color scale	Format detail cells separately
Using colors with no meaning	Reviewers misread the sheet	Define what high and low mean
Applying one scale to mixed metrics	Values become incomparable	Use separate rules by metric
Hiding the numbers completely	Detail is lost	Keep values visible unless the grid is only diagnostic

TIP

If one extreme value makes every other cell look the same, set custom minimum and maximum values in the conditional formatting rule.

The Griddy way

Heat maps work best when the underlying grid is already clean.

"Create a heat map from this weekly restaurant schedule so I can see the busiest coverage windows and thin staffing blocks"

Griddy can reshape the source data, choose a practical grid, and apply conditional formatting that supports the review instead of overwhelming it.

Keep the heat map interpretable

Choose a color scale whose midpoint has a meaningful interpretation, such as zero, a target, or the median. Keep the same scale when comparing periods so a color does not change merely because the range changed. Add row and column labels, preserve the underlying values, and avoid using color as the only signal for an important exception. Check the view in grayscale or with a color-vision simulation when the workbook is used for decisions. A heat map is a scanning aid; pair it with exact values and a short explanation of what action each threshold should trigger.

Sources

Do this with AI

Turn the instructions into a finished spreadsheet.

Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.

Try Griddy freeStart in your browser. No download required.

Also works withExcel Google Sheets

Use this on real templates

Use heat maps on dense operating templates

Heat maps help managers scan staffing, spend, risk, and workload patterns across the templates they already review each week.

All posts