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

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to use Excel 2007's new features for conditional formatting to highlight the unique or duplicate values in a list of data within the spreadsheet. This is a great tutorial for users who need to regularly analyze large sets of data since it allows them to quickly identify if there are record entries that need to updated or changed. This is a simple and useful portion of the conditional formatting feature that anyone can use.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel guides
• tips
• tricks
• tutorial
• formatting in excel
• conditional formatting
• highlight duplicates
• highlight unique values
• organize data
• format information 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.