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:

https://www.youtube.com/channel/UCSd9vq86eRNejw_WoxlSFZw?sub_confirmation=1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.