Creating a Dynamic Heat Map in Excel Using Scroll Bar

In this video, you'll learn how to create a dynamic heat map in Excel using conditional formatting and scroll bar.

This type of heat maps can be useful when you are creating dashboards or reports and want to save space on the worksheet. While it takes less space, it still allows the user to access the entire data set.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[mohamedsaid]

Thank you very much for this awesome lesson

[jaredfromtexas]

Good video. This scroll-bar method will come in handy for me for limiting viewing to a more manageable subset of the whole. I was playing around with the setup and if you want the color range to be red to green for the entire original data set, not just the 3x12 shown, you can have 2 helper cells below the 3x12 set which are MIN and MAX and refer to the 7x12 original set. Then include these 2 cells when setting the conditional formatting, so they get set to red and green, but then hide this row. This can be helpful if the data is something like increasing profits and you want the cells to appear more green as you keep scrolling right to more recent years.

[ruairihair]

awesome work man. I hadn't considered using this combination before.