How to find out the duplicates and highlight them?

		Microsoft Office Forums > Microsoft Excel > Excel
How to find out the duplicates and highlight them?

06-29-2011, 10:14 PM

Learner7

Windows XP How to find out the duplicates and highlight them?

Office 2007

Advanced Beginner

Join Date: May 2010

Posts: 51

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 AM.