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" wrote:

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

--
Biff
Microsoft Excel MVP


"wally" wrote in message
...
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.


.