Excel Formatting Tip 2 - Highlight Unique or Duplicate Values with Conditional Formatting in Excel

[airpigs]

Hi, how can you highlight duplicates from groups of cells? say I have data in Columns A, B, C and now I want to highlight duplicates in columns D, E, F. However, I do not want duplicates within A,B,C to be highlighted if they have duplicates in columns A,B,C. ??

[ExcelisHell]

If I understand correctly, you just need to select the columns separately and then apply the conditional formatting.

[airpigs]

Thank you for replying so quickly! that wouldn't work either. If I have data on A and I want to see if there are duplicates on B only, I don't want it to highlight duplicates within A. Say on A I have CAT CAT DOG and column B had MOUSE DOG MOUSE I only want "DOG" to be highlighted because it's in both A and B. what I don't want is to see CAT in column A and MOUSE and column B highlighted because they are not found on each others column... ? I hope I'm making sense here.

[msscience]

Thank you very helpful.