Duplicate entries

  • Thread starter Thread starter wally
  • Start date Start date
W

wally

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.
 
Based on this sample, tell us what cells would be highlighted and with what
color:

A1: 1
A2: 1
A3: 1
A4: 1
A5: 1
 
A1 - no color
A2 thru A5 would be yellow.

What I'm looking for is:
A1 - no color
A2 - Yellow
A2 thru A5 - something like red
 
Ok, try this....

Select the *entire* range
Goto Format>Conditional Formatting
Condition 1
Formula Is: =COUNTIF(A$1:A1,A1)=2
Click the Format button
Select the Patterns tab
Select the color desired
OK

Click the Add button

Condition 2
Formula Is: =COUNTIF(A$1:A1,A1)>2
Click the Format button
Select the Patterns tab
Select the color desired
OK out
 
Back
Top