i have an excel worksheet with about 10K rows of data in column A.
i have also another list of data, about 200 rows of data, in column G.
i need to color each cell in column A that contains, anywere in the string, any of the data strings in column G.
example:
in column A
row 1: [email protected]
row 2: [email protected]
row 3: [email protected]
row 4: [email protected]
in column G:
row 1: help
row 2: info
row 3: support
i need rows 1, 3 and 4 in column A to be colored.
thank you in advance for your help!
Mario
Bookmarks