How to Create Dynamic Heat Map with or without numbers in Excel - Office 365

A heat map is a visual interpretation of numeric data where different values are represented by different colors. In Excel a heat map is used to display individual cells in different color codes based on their values. Heat map can be created by using conditional formatting color scale. This video explains the how to create following heat maps

1. Create a temperature heat map of a certain region
2. Create a heat map using custom color scale
3. Create a heat map without numbers
4. Create a heat map with square cells
5. Create a dynamic heat map using a checkbox
6. Create a dynamic heat map without numbers
7. Create a heat map with radio button control to either display or not

To download the practice Excel file please click on the link below

To learn more about conditional formatting of cells in Excel please click on the link below