Highlite Duplicates in 2 Columns (Conditional Formating)

[Mike 215]

Hi,
I have 2 columns of data.
Both Columns can contain duplicates
How can I find duplicates in both columns.

A B
1 Car Toy
2 Ball Toy
3 Bed Bar
4 Car Toy
5 Ball Bar

A1, B1, A4 & B4 should be hi-lited with Conditional Formating
Thanks for your help.

 

[Eduardo]

Hi,
take a look at CPearson web

http://www.cpearson.com/excel/Duplicates.aspx

if this helps please click yes, thanks

 

[Mike 215]

Hi,
take a look at CPearson web

http://www.cpearson.com/excel/Duplicates.aspx

if this helps please click yes, thanks







- Show quoted text -

Eduardo, thanks for responding so quickly.
I started looking in cpearson.com/excel/Duplicates,
but was unable to make versions of his formulas work to hilight both
columns if both are duplicated.

 

[Chip Pearson]

It isn't clear whether you want to highlight duplicates within a
column (ignoring values in the other column) or look for duplicates
across both columns. Moreover, why are A2 and A5 not considered
duplicates, since both contain "Ball". Similarly, all the entries in
column B are duplicates of one another, so the all the entries should
be highlighted.


Provide more accurate details.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)