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?