Check out this web site of Chip Pearson.

Scroll down to the D's, and see all the articles on dealing with duplicates.


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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kris" wrote in message
...
I am working in 1 worksheet and have data in 2 columns and I would like to
search for duplicates and have the matches highlight automatically.

Below is an example:

Tenant Debit Credit
ABC $500
ABC $500

Then the 2 duplicate entries would be highlighted in blue.

I am somewhat of a beginner at the function entries, so please explain the
steps in detail.