|
|
#2
06-17-2016, 11:23 PM
|
||||
|
||||
You don't need a macro for this - you can do it with a conditional format using the formula:
=COUNTIF($A$1:A1,A1)>1
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sequencing duplicates | balajigade | Excel Programming | 3 | 10-04-2015 03:31 PM |
 VBA: Delete duplicates in each row
|
bandaanders | Excel Programming | 2 | 09-02-2015 08:15 AM |
|
Removing duplicates
|
saurabhlotankar | Excel Programming | 14 | 05-26-2015 10:13 AM |
| Mail duplicates | mixy | Outlook | 0 | 02-10-2011 12:54 AM |
|
sum of duplicates
|
zxmax | Excel | 1 | 09-29-2006 08:29 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode