Duplicates

[pfmje]

HI All, 

I hoping to get help with the following:

I have one workbook - 2 sheets.  I am trying to determine if the data in Sheet 1 Column A is duplicated on Sheet 2 Column A, B or C.  I know I can find the dups by applying conditional formatting and creating a rule of  =(COUNTIF(Sheet1!A:A,B1)>0)  and instructing to highlight those that match the criteria. But what about 3 columns?

Any help would be greatly appreciated!  Thanks, 

[#2]

Hello @pfmje,

Apply this conditional format to cell A1 in Sheet 2:

=COUNTIF(Sheet1!$A:$A,A1)

and apply the format painter across all cells in column A, B, and C.

Hope this helps!

PReagan

[#3]

@PReagan 

Format Painter will generate as many rules as to how many cells you apply it. It's enough to apply one rule to entire range as =$A:$C