|
|
#1
08-05-2013, 01:42 AM
|
|||
|
|||
Conditional Formatting Duplicates
Hi, I have a column containing several thousand VAT numbers and I want to highlight the duplicates. I have tried conditional formatting, but that picks up all those that are TBC or Not Registered, which I don't want highlighted. I can't see how to exclude text (or include numerical values only). I would be grateful for some help on this. Thank you. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
 Using Conditional Formatting to identify duplicates
|
namedujour | Excel | 3 | 05-24-2012 05:55 PM |
|
Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode