Find & Replace problems... at the end of my thread (ha)

[dunndealpr]

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

I CTRL-H then enter the info as you see it in the pic attached. When
click Replace All it says "that function is not valid". It works like
charm for every other word I test it with. It's almost interesting in
head-exploding kind of way.

Any ideas

+-------------------------------------------------------------------
|Filename: Untitled-1.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=882
+-------------------------------------------------------------------

 

[Claus Busch]

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

 

[dunndealpr]

Hi,

Am Thu, 6 Jun 2013 16:05:29 +0100 schrieb dunndealpr:
-
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

interesting! wasn't hip to conditional formatting. not hip to formula
either, but it seems i don't even need them to get what i need don
here. thanks!

it just seems like find and replace should have worked regardles
though. that vexed me to no end

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Ron Rosenfeld]

it just seems like find and replace should have worked regardless
though. that vexed me to no end.

It worked fine for me with Excel 2007. Of course, it only highlights the cell, not the entire row.