Highlight exact match in column

  • Thread starter Thread starter mgbcab
  • Start date Start date
M

mgbcab

I have a column with 10000 entries. I want to highlight duplicate cells that
have the exact same text string order.
I would have the following:

Cap
Fernco Cap
Coupling
Coupling
Fernco Coupling
Fernco Coupling
Fernco Coupling
Fernco Coupling
Fernco Coupling
Where as the 1st 2 lines are not matching but the remaining would be
duplicates. I would like to highlight not delete these cells. Or find the 1st
one and cross-out the remaining.
 
Using excel 2007:

If your items are in column A, select A to highlight the whole column, then
go into your conditional formatting. Select New Rule..., Select "Use formula
to determine which cells to format. In the Format Values... box put:

=A1=A65536

Press the format button and select your formatting. Press ok twice. In the
"Applies to" box put: (if it is not already there)

=$A:$A

Apply and ok.

Squeaky
 
Thanks this work great but now I another problem to address. I would like to
count the number of duplicate cells based this CF. I have tried VBA codes but
they do not seem to work with a formula based CF and only count manually
colored cells. I also could sort the colored cells then have a helper coulmn
to count them or just have a cell to count the column of CF cells.
 
Back
Top