Hi,

Am Thu, 6 Jun 2013 16:05:29 +0100 schrieb dunndealpr:

Hey guys. I have Excel 2007. I have a spreadsheet with email addresses
in it surrounded by other text. I want to automatically highlight in
yellow each row containing the words gmail, yahoo, hotmail and so on.

your strings in column A. Then try in B1:
=--(COUNT(FIND({"yahoo","gmail","hotmail"},A1))0)
Enlarge the formula for all other searched providers.
Select A1:Bn = Conditional Formatting = new Rule = use formula ...
and as formula:
=$B1=1 and format with your wished back color.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2