View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Duplicate entries

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"wally" wrote in message
...
That works. Thanks!!!
I really appreciate what you guys do for us.

"wally" wrote:

I have been using Conditional Formatting to indicate duplicate entries in
a
column. This highlights entries seen 2 or more times. This is working
well,
however the need has expanded to highlight not only duplicates seen for
the
first two times, but the third or greater time by a different highlight
color. This application indicates a warning for the second occurrence,
and
an action with the third occurrence.

Your help would be appreciated.