Compare rows and highlight differences

Hi All

I've attached a sample workbook as I've been thinking and thinking about this, and I'm just stuck.

I have a workbook that searches for matches and puts them in a tab called 'reported on' - it then finds truly new entries and puts them in a new tab and then finds partial matches, and puts them in the sheet that I have attached.

Partial matches are found by comparing Column C, O & P. It then puts them in a sheet together - puts New or Old at the end - Old states it has been reported on previously, whilst New was highlighted in the new report.

Now, the only cells that will ever differ are M, N or T.

What I am looking to have happen is that all that have the word New at the end - the whole row is highlighted in light blue.

Then the cell thats changed, for arguments sake N have the text bold and the cell highlighted yellow.

At the end of the process the ones with Old are removed, and Column U deleted, but the formatting to stay. I can do the deleting those with Old in without a problem - but the formatting I am stuck with....

Please please help =)

Forum Upload.xlsx

I don't understand the purpose of changing the color of rows that are "New".
At the end of the process, rows of "Old" will be deleted anyway....?

Please Login or Register  to view this content.

The reason for colouring is that at the end of the process these rows go into a much bigger spreadsheet - but these ones that have had changes remain highlighted so they can be identified quickly.

Cheers for the codes guys - they seem to do the trick