Highlite Duplicates in 2 Columns (Conditional Formating)
 

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.

Highlite Duplicates in 2 Columns (Conditional Formating)
 

Hi,
take a look at CPearson web

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

if this helps please click yes, thanks

"Mike 215" wrote:

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.

Highlite Duplicates in 2 Columns (Conditional Formating)
 

On Aug 14, 12:00*pm, Eduardo
wrote:
Hi,
take a look at CPearson web

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

if this helps please click yes, thanks



"Mike 215" wrote:
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.- Hide quoted text -

- 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.

Highlite Duplicates in 2 Columns (Conditional Formating)
 

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)

On Fri, 14 Aug 2009 09:13:48 -0700 (PDT), Mike 215
wrote:

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.