Jun 27 2019 11:06 AM
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,
Jun 27 2019 12:29 PM
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
Jun 27 2019 01:18 PM
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