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?
|