I'm looking for a way to highlight duplicate rows that cover a series of
cells. For example, each row in A1:A5 must match each row in A55:E55 to be
considered a duplicate.

What's the best way to go about this?

probably add a column which concatenates the data from the used cells in a
row - depends on how many columns you have
you could then use the countif() formula to highlight where the duplicates
are ( countif 1)



"Rugby Stud" wrote in message
...
I'm looking for a way to highlight duplicate rows that cover a series of
cells. For example, each row in A1:A5 must match each row in A55:E55 to
be
considered a duplicate.

What's the best way to go about this?