Hi!

Maybe not exactly what you had in mind but at least it's something!

You would need to use specific keywords or phrases from the 2 nd column
entries and then you could search for matching keywords in the 1 st column
and use conditional formatting to highlight the matches. The big drawback
that I see is that this would have to done one at a time. The basic concept
is the same as that used in a database except that you're not wanting to
extract the data, just highlight any matches. I use this concept in my music
database (Excel) except that I do extract the data. For example, I enter a
keyword or phrase in a cell then the database is searched and every entry in
the database that contains that keyword or phrase is extracted.

Can you post a sample file?

Biff

"ebraun01" wrote in
message ...

Anybody got any suggestions?


--
ebraun01
------------------------------------------------------------------------
ebraun01's Profile:
http://www.excelforum.com/member.php...o&userid=30340
View this thread: http://www.excelforum.com/showthread...hreadid=500035