Create a Heat Map in Excel
In this video, we will see how to create a Heat Map in excel using conditional formatting. We will also add dynamic benchmarks in our heatmap in excel to control the color gradient of the values.
We will also look at how we can hide the values in Heat Map so that the table is transformed into a visual indicator of low and high values.
Click here to subscribe to my channel to get more videos of Excel formula tips and uses:
/ @exceltipsvideos