I am trying to write a vba to change the cell color by looking in a range that contains the color index value.
example:
Range B2 thru B500 have a value lets say "America" and in range z1 thru aa10 there is a table that contains the name in column z (america) and color index value in column aa (6).
So if cell B3 = America then the color that cell should be 6 (which is yellow)
Bookmarks