• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Heat Map with a Data sheet and a Layout sheet

gmcd35

New Member
I'm looking to create a Heat Map based on Inventory movement within my warehouse. I am having issues with conditional formatting and/or VBA. What i'm looking for is that I pull basic information in to the data sheet, information consist of sku#, Location and Sales History. I have a layout sheet which shows my warehouse layout and the cells represent Location. I would like to highlight the corresponding Location in the Layout sheet by sales history if there is a sku# in Data file with the same Location.
 

Attachments

  • Sample Heat Map.xlsx
    41.4 KB · Views: 8
In the attached, on the Layout sheet at cell K1 there's a button. Clicking it will fill the cells B2:E14 with colours.
What I've done:
Simple formulae in hidden columns in cells F2:I14
Conditional formatting applied to those cells
Clicking the button will transfer the displayed fill colours in those cells to the actual fill colours of the cells 4 cells to the left.

If I can think of a more straightforward way I'll post again.
 

Attachments

  • Chandoo47899Sample Heat Map.xlsm
    48.9 KB · Views: 18
Back
Top