|
|
#2
07-26-2011, 01:51 AM
|
|||
|
|||
you can simply use conditional formatting to do this. Select the two columns, Open conditional formatting , highlight cells for double data, no matter if data is numeric or text. This will work even if you continue to add data to those columns, if you add a value that already added, it will be highlighted automatically.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to compare 2 columns with other two columns in EXECL 2007?
|
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
|
Comparing Word Documents
|
NepalKat#1 | Word | 1 | 01-09-2010 11:18 AM |
| macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |
|
could you help me help me with advanced filter
|
Nora | Excel | 1 | 05-15-2009 11:10 AM |
|
Comparing Data
|
leroytrolley | Excel | 1 | 08-09-2008 08:34 PM |
Windows Vista 
Office 2007
Threaded Mode