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: info@duende.com
row 2: rasko@silvester.com
row 3: supportonline@fabius.com
row 4: myhelp@friday.com
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