need filtering help
 

I have last names in two different worksheets ; I have taken the lst names
from one and pasted them into a column in the other - what is the conditional
formatting to find the matching last names?
Thanks.

need filtering help
 

You can use the techniques on Chip Pearson's site, to mark the names
that are in both lists:

http://www.cpearson.com/excel/duplicat.htm


Lauri wrote:
I have last names in two different worksheets ; I have taken the lst names
from one and pasted them into a column in the other - what is the conditional
formatting to find the matching last names?
Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html