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.
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.