Thread: How to find out the duplicates and highlight them?
View Single Post
 
Old 06-29-2011, 10:14 PM
Learner7 Learner7 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default
Quote:
Originally Posted by Kimberly View Post
  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
Thanks for your kind help. It wokrs for me.

Regards.
Reply With Quote