Highlite Duplicates in 2 Columns (Conditional Formating)

  • Thread starter Thread starter Mike 215
  • Start date Start date
M

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.
 
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)
 
Back
Top