Thread: How to find out the duplicates and highlight them?
View Single Post
 
Old 06-29-2011, 08:35 AM
Kimberly Kimberly is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default
  1. In a new column, concatenate the first 3 columns. (e.g.: =A1&B1&C1 and copy down)
  2. Select this new range
  3. On the Home tab, click Conditional Formatting > Highlight Cell Rules > Duplicate Values
Reply With Quote