I have a number of rows within a large spreadsheet that have some identical rows I would like those rows highlighted but only if every cell on the row matches, if random cells from different rows match, but not every cell on the row, the cell / row should be ignored.
So here you can see the desired effect Rows 191 and 192 are identical and have been highlighted. However even though the data in cells B190-B193 are the same, as is the data in cell N191-N193. The data in Cells that do not full match the other cells in their row have not been highlighted.
Using conditional formatting and other attempts mark any duplicate field and not ones where the entire row is identical.
Would appreciate any help, totally stuck!