Assuming your list of values / entries are in col. A,
select the column, go to Format CF, choose "Formula Is"
on the drop-down list, and put:

=COUNTIF($A$1:$A1,$A1)1

Click the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
Does anyone know how to use the conditional formatting
command to find the
duplicates in a cell?


.