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

"mgbcab" wrote:

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.