I'm trying to highlight dupe rows in Excel '03. In column Q I have concatenated all of the cells I want to check. For example, an entry in cell Q1 might look like:
John Doe 300 Whit Drive Pittsburgh PA 00001-5235
To highlight dupe rows of data, I am using condition formatting with the the...