View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Wally Wally is offline
external usenet poster
 
Posts: 42
Default Duplicate entries

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.