Ok here's where I am at this point:
I have an excel workbook that has a static "map" where cells represent physical locations in a store. Each cell on that map has a location code entered as its value. I'm attempting to get the static location code cells on the map to change color based on the sales numbers associated with that location. I've attached a workbook that gives a pretty accurate depiction of the type of interface we're talking about.
Here's where I'm stuck. I can't figure out how to get conditional formatting to identify that if any cell in a range (my example workbook is A1:C7) matches the value of any cell in H (attached example) the sales data from the corresponding cell in I will dictate the color shading based on distance from the AVG of column I. I've used a Pivot Table to pull the data from another spreadsheet in the file I'm working on, however I'm just interested in getting this to work period.
Any help (or guidance) will be greatly appreciated. It's annoying because I can conceptualize what I need to do, just not HOW to do it.
Static Locations.xlsx
Bookmarks