I have two columns of data. Column 1 contains a list of email address domains such as
gmail.com, yahoo.com, mydomain.edu, myotherdomain.org etc. The second column contains a list of complete email addresses, ex.
I want to highlight every email address in column B that has a substring match of one of the domains in column A.
For example, in column B I have the address
firstname.lastname@example.org and the string
domain1.com in column A. That address in column B should be highlighted. If I have
email@example.com in column B but the string
domain2 does not appear in column A, the email address must not be highlighted.
How can I do this?