You could use a formula in column C that would indicate if the value in column B
appears anywhere in column A.

=isnumber(match(b1,a:a,0))

And drag down as far as you need (all 1000 rows).

If you see True, there's a match. If you see False, then there's no match.

You could apply data|filter|autofilter (xl2003 menus) and even filter to show
just what you wanted.

Jeff M wrote:

I have two lists of account names (for example). 500 names in column A and
1000 names in column B. I would like to highlight or somehow alter the names
in column B that are in Column A without using the find and replace
function.. I do not want to do it one at a time but cannot figure out how to
do it with the entire range all at once? Goal is to then use the data
associated with the highlighted cells in column B for reports etc.

--

Dave Peterson