Conditional Formatting

L

Leslie Burns

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

Jason Morin

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
 
K

KemS

Jason,

Any thoughts on whether a similar method could be used to locate duplicate
records in an Excel database? And if possible, is there any way then to sort
based on the records conditionally formatted (to delete them)?

E.G. 8500 single row records of Name, Addr, City, St, Zip, etc of which one
or more are duplicates. The objective: highlight and sort out the
duplicates.

Thanks,
Kem
 
Top