Create a heat map table

Imagine you have some data showing performance of some teams in different categories:

A very quick way of showing the results more visually is to create a thermal map.  You can do this very quickly using conditional formatting!  Download the sample excel sheet here.

• First, highlight the values in the first column (result 1)
• Then on the Home tab, click on the small arrow next to the Conditional Formatting button (in the Styles section)
• Click on Color scales and then More Rules

• Ensure that “Format all cells based on their values is selected
• Then in the Edit the Rule description section, choose a 2-color scale and choose 2 colors.  I’ve left the default colors in place for the first column (orange and light orange)

• When you are done, press the OK button.  The column should automatically update

• You can then repeat this for each of the other columns, using different…