Hi all - I wonder if someone can help with this issue...

I have two sheets of similar data - the first (sheet 1) with 1865 rows and is a newer version of the other (sheet 2) with 1806 rows (data in columns A-Y).

I want to do the following, ideally giving me fresh data on a separate sheet:
1 - remove all rows that are exactly the same across the two sheets.
2 - highlight the brand new row data held in sheet 1 that is not on sheet 2.
3 - highlight the row data from both sheets that is similar but has changed (e.g. the data in column c might have changed, or a name spelling).

Does this make sense?

Any help greatly appreciated!