Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/05/Heat-Map.xlsx

In this video I demonstrate how to create a heat map using Microsoft Excel. This is easily done using conditional formatting colour scales. The heat map can displayed with out without numbers and can be applied on a per row basis if required.

Table of Contents:

00:00 - Introduction
00:40 - Apply heat map using colour scales
03:24 - Hide numbers in your heat map
04:35 - Create specific numeric ranges for your heat map colours
------------------------