Select the entire range (suppose it is A1:A10)
Go to Format > Conditional Formatting
Select 'formula is'
and enter the formula:
=COUNTIF($A$1:$A$10,A1)>1
apply some format by clicking on the format button.

Mangesh