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.
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
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.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and 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.
Employee Schedule for Restaurants
Plan restaurant shifts, opens, closes, stations, and coverage in one free staff schedule spreadsheet built for restaurants and cafes.
Open templateFinanceExpense Tracker for Restaurants
Track restaurant food costs, labor support, supplies, repairs, delivery fees, vendors, and receipts in one expense spreadsheet.
Open templateProject ManagementProject Tracker for Restaurants
Track restaurant openings, menu updates, repairs, vendor tasks, marketing projects, owners, blockers, and due dates in one sheet.
Open templateHREmployee Schedule
Plan a weekly staff rota with day-by-day shifts, weekly hours, overtime flags, and a manager snapshot block. Free template for teams, shops, and clinics.
Open template