How to find out the duplicates and highlight them?

Microsoft Office Forums

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

Prev

Previous Post

Next Post

Next

#4

Old

06-29-2011, 08:35 AM

Kimberly

Kimberly is offline

How to find out the duplicates and highlight them?

Windows 7 64bit How to find out the duplicates and highlight them?

How to find out the duplicates and highlight them?

Office 2010 64bit

Expert

Join Date: May 2010

Posts: 517

Kimberly is on a distinguished road

Default

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

Reply With Quote

« Previous Thread | Next Thread »

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 06:07 AM.