Thread: Filtering Data in ranges and changing duplicate cells to a color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote