Highlight duplicate values in a column

Menu -> Format -> Conditional Formatting -> Custom Formula

=COUNTIF($A$2:$A$1000,$A2)>1