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.