Duplicate entries
 

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.

Duplicate entries
 

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.

Duplicate entries
 

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.


.

Duplicate entries
 

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.


.

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.

Duplicate entries
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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