Column 1 has a locations(HA01-01-A1,HA01-01-A2.....etc) and column 1 is divided into four categories and in column 2 a specific color is filled beside different categories. In another worksheet layout locations of the warehouse(HA01-01-A2 etc..) are present.I wanted the corresponding colours to be filled in the locations according to the category
Solved by D. L. in 14 mins