|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 27th, 2008, 09:40 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Filtering Data in ranges and changing duplicate cells to a color
I use 2003 and need to know how to change the color of a duplicate field so
that it will alert me there is a duplicate. 
|
|
#2
March 27th, 2008, 10:33 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Filtering Data in ranges and changing duplicate cells to a color
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx looneylmt wrote: I use 2003 and need to know how to change the color of a duplicate field so that it will alert me there is a duplicate. -- Dave Peterson
|
|
#3
March 28th, 2008, 06:51 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Filtering Data in ranges and changing duplicate cells to a col
That worked, thanks, the only thing is that there are about 200 numbers that
it has to compare and now it is slow. I may just filter it instead. Thanks. "Dave Peterson" wrote: Chip Pearson has lots of techniques to work with duplicates: http://www.cpearson.com/excel/Duplicates.aspx looneylmt wrote: I use 2003 and need to know how to change the color of a duplicate field so that it will alert me there is a duplicate. -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
