Creating a Dynamic Heat Map in Excel Using Scroll Bar

[@jaredfromtexas7484]

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.

[@preetipimpalnerkar2910]

Awesome 🙏👍

[@mohamedsaid7514]

Thank you very much for this awesome lesson

[@ruairihair]

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

[@loajungfung5070]

Susah dapat orderan exspres