Duplicate items
 

If I have the following:


Column A

Mike Soren
Jim McGree
Paul Jackson
James Banton
Mike Soren


How can I have a formula that notices I just entered in "Mike Soren" a
second time in column A?
and maybe it will change the color of the text? or sound a warning
beep?

Duplicate items
 

Hi,

Conditional formatting should do what you want.
Select your column of data including empty cells where you may enter
additional names and then

Format|Conditional format
Select 'Formula is'
enter the formula
=COUNTIF($A$1:$A$100,A1)1
Pick a colour and click OK

Duplicated names will now be highlighted and if you add a new name that is a
duplicate both will be highlighted. Change Column A to your column

Mike

" wrote:

If I have the following:


Column A

Mike Soren
Jim McGree
Paul Jackson
James Banton
Mike Soren


How can I have a formula that notices I just entered in "Mike Soren" a
second time in column A?
and maybe it will change the color of the text? or sound a warning
beep?

Duplicate items
 

Assuming that your data are in A1:A100 you could use following conditional
formatting formula for A1 (Menu Format|Conditional Formatting):

=COUNTIF($A$1:$A$100,A1)1

apply the desired format for this condition, push 'OK' and copy the format
down to A100 (easiest way is to use the format painter).

JM



wrote in message
...
If I have the following:


Column A

Mike Soren
Jim McGree
Paul Jackson
James Banton
Mike Soren


How can I have a formula that notices I just entered in "Mike Soren" a
second time in column A?
and maybe it will change the color of the text? or sound a warning
beep?

Duplicate items
 

I shouild have added change the 100 to the row number appropriate for you range

"Mike H" wrote:

Hi,

Conditional formatting should do what you want.
Select your column of data including empty cells where you may enter
additional names and then

Format|Conditional format
Select 'Formula is'
enter the formula
=COUNTIF($A$1:$A$100,A1)1
Pick a colour and click OK

Duplicated names will now be highlighted and if you add a new name that is a
duplicate both will be highlighted. Change Column A to your column

Mike

" wrote:

If I have the following:


Column A

Mike Soren
Jim McGree
Paul Jackson
James Banton
Mike Soren


How can I have a formula that notices I just entered in "Mike Soren" a
second time in column A?
and maybe it will change the color of the text? or sound a warning
beep?

Duplicate items
 

On Aug 19, 12:44*am, Mike H wrote:
Hi,

Conditional formatting should do what you want.
Select your column of data including empty cells where you may enter
additional names and then

Format|Conditional format
Select 'Formula is'
enter the formula
=COUNTIF($A$1:$A$100,A1)1
Pick a colour and click OK

Duplicated names will now be highlighted and if you add a new name that is a
duplicate both will be highlighted. Change Column A to your column

Mike



" wrote:
If I have the following:

Column A

Mike Soren
Jim McGree
Paul Jackson
James Banton
Mike Soren

How can I have a formula that notices I just entered in "Mike Soren" a
second time in column A?
and maybe it will change the color of the text? or sound a warning
beep?- Hide quoted text -

- Show quoted text -

Mike thank you so much! that helped me big time!! I really appreciate
it!