Duplicate entries

[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.

 

[T. Valko]

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

 

[wally]

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

 

[T. Valko]

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

 

[wally]

That works. Thanks!!!
I really appreciate what you guys do for us.

 

[T. Valko]

You're welcome. Thanks for the feedback!