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.