What are HeatMaps in Excel?

A Heat Map in Excel is a visual representation that quickly shows you a comparative view of a dataset. For example, in the dataset below, I can easily spot which are the months when the sales were low (highlighted in red) as compared with other months.

Creating a Heat Map in Excel Using Conditional Formatting

  1. Go to Home –> Conditional Formatting –> Color Scales –> More Options.
  2. In the New Formatting Rule dialog box, select ‘3-Color scale’ from the Format Style drop down.
  3. Now you can specify the minimum, midpoint, and the maximum value and assign the color to it.