Hello,
Does anyone have an idea how to solve my problem in the quickest way? I was thinking about conditional formatting.
So i have got warehouse map with locations. I want to highlight all locations on map in one color (these locations gonna be changing daily, they gonna appear in different sheet [see pic1]).
The rest needs to by highlighted in second color.
Locations Data:
map2.JPG
Map:
map.JPG
I dont know if ive explain that right.
Thanks for any help.
Bookmarks