Partial Match - domains to email addresses

supermajda 

I suggest conditional formatting to identify all email addresses for a certain domain. I entered data validation for all domains (3 in this example) in A1 and chose "adidas.com" and all email addresses containing "@adidas.com" in column B are highlighted.

I entered this formula (rule) for conditional formatting;

=COUNT(FIND("@"&$A$1,B1))

and in the manager for conditional formatting, in the field "applies to" i entered:

=$B$1:$B$1000

This can be adjusted to the requirements.