Conditional Formatting
 

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

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?


.

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

"Jason Morin" wrote:

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?


.