Ok, try this....

Select the *entire* range
Goto FormatConditional 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

--
Biff
Microsoft Excel MVP


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


.