Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
Does anyone know how to use the conditional formatting command to find the
duplicates in a cell? |
#2
|
|||
|
|||
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? . |
#3
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |