To highlight duplicates:
Select column A
From Format menu | Conditional Formatting
Formula Is: =COUNTIF($A:$A, $A1)1
Then format as Bold, or Red or whatever.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bruce" wrote in message
...
Is there an easy way to prevent creating duplicate
entries within a given column in Excel?
Alternately....is there a way to automatcially highlight
a cell / row when a duplicate entry is created within a
given column?