Conditional Formatting

  • Thread starter Thread starter Leslie Burns
  • Start date Start date
L

Leslie Burns

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Highlighting duplicates 0
Negative Conditional Formatting Excel 2003 2
Copying conditional formating 2
Excel Conditional Formatting 1
Excel Conditional Formatting Removal 7
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting 1

Back
Top