Highlight duplicate rows in Excel

[Miasha]

I am trying to highlight rows in my Excel spreadsheet that contain the same data. I have tried using 'Conditional Formatting,' 'Highlight Cells Rules,' 'Duplicate Values' option. However, this highlights any cells that contain the same information. I only want the entire rows highlighted that match exactly. For example:

Mary Smith 1234 Main St.
Jack Smith 349 Willow Rd.
Mary Rogers 16th St.
Jack Smith 349 Willow Rd.

Using the above stated option gives me the following results which I do not want:

Mary Smith 1234 Main St.
Jack Smith 349 Willow Rd.
Mary Rogers 16th St.
Jack Smith 349 Willow Rd.

I am using Excel 2010. Thanks for your input.

 

[Boller]

Assuming you have a fixed number of columns that can contain data, use another column (hidden if you like) to concatenate that data from all the other data columns, and then use conditional format on the concatenated column.

 

[MrKowz]

How many criteria would define a "duplicate row"? It is possible, but very ineffecient, to test an ENTIRE row against all other rows.

 

[Boller]

How many criteria would define a "duplicate row"? It is possible, but very ineffecient, to test an ENTIRE row against all other rows.

Not inefficient if my suggestion is follwed.

 

[Miasha]

Assuming you have a fixed number of columns that can contain data, use another column (hidden if you like) to concatenate that data from all the other data columns, and then use conditional format on the concatenated column.

Thank you. This will work!