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

[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.

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

Any ideas?

[newdoverman]

The search and replace should highlight the cell that contains gmail.

If you were wanting to highlight the entire row use Conditional Formatting, Use formula and enter this formula adjusted to suit your data:

Please Login or Register  to view this content.

[dunndealpr]

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

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

[newdoverman]

I don't know why Search and Replace didn't work for you. My setup was exactly what you show in the picture. (a copy of your data minus confidential stuff) would perhaps have shed some light on the subject.