Conditional Format duplicate rows

[smblair]

I am trying to figure out how to conditionally format rows that are exact duplicates of each other? I have been playing around with "=COUNTIF(A:K,A1:K1)>1"
I need this to work in both Excel 2003 and 2007.
Thanks

 

[jbeaucaire]

To do this simply, I would add a column for this test. If column M were empty, then in M1 you could put:

=A1&"-"&B1&"-"&C1&"-"&D1&"-"&E1&"-"&F1&"-"&G1&"-"&H1&"-"&I1&"-"&J1&"-"&K1

Copy the down your dataset. The column can be hidden for tidiness, if necessary.

Now it's an easy CF formula.

=COUNTIF($M:$M, $M1)>1

 

[smblair]

Clever little work around, works like a champ. Thanks