How to find out the duplicates and highlight them?

Kimberly · #1 06-29-2011, 08:35 AM

In a new column, concatenate the first 3 columns. (e.g.: =A1&B1&C1 and copy down)
Select this new range
On the Home tab, click Conditional Formatting > Highlight Cell Rules > Duplicate Values

Learner7 · #2 06-29-2011, 10:14 PM

Quote:

Originally Posted by Kimberly

In a new column, concatenate the first 3 columns. (e.g.: =A1&B1&C1 and copy down)
Select this new range
On the Home tab, click Conditional Formatting > Highlight Cell Rules > Duplicate Values

Thanks for your kind help. It wokrs for me.

Regards.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and highlight multiple words in MS Word document	AtaLoss	Word VBA	37	09-22-2021 12:04 PM
Highlight text and find next instance	DrDOS	Word	0	11-15-2010 04:02 PM
Find duplicates formula	hannu	Excel	2	10-26-2010 02:48 AM
find - reading highlight - highlight all / highlight doesn't stick when saved	bobk544	Word	3	04-15-2009 03:31 PM
sum of duplicates	zxmax	Excel	1	09-29-2006 08:29 PM