Creating Heat Maps
A heat map is nothing but a visual representation of data where color changes based on the value. For example, you can create a heat map where a cell with highest value is colored green and there is a shift towards red color as the value decreases.
Something as shown below
To create this, go to Home –> Conditional Formatting –> Color Scales, and choose one of the color schemes
Note: Similarly, you can also insert data bars or Icon sets