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

D

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
+-------------------------------------------------------------------
 
C

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
 
D

dunndealpr

Claus said:
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

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top