Compare a table content to previous table content

[albertan]

I have a monthly extract with a report with projects that have 50 columns. Each column represents information that may change next month. Next month I get the same type of report which may have:
- new projects
- some records under any of the 50 columns may have changed

Is there a report I can run to come up with what has changed during the month, i.e. 1) which project numbers were added and 2) for existing projects: which records have changed under any of the 50 columns

I have been trying to think what is the best way to do it. I thought to use Power Query but so far it is becoming a long exerices because I have been using boolean logic to compare each column of current month and previous months report. But it is a quite long exercise. Thank you all in advance for any tips you may have

 

[Legacy 143009]

Are you good at VBA?

If I were you, I would loop through each number on project column.

If a number doesn't show up in the previos table, then color entire row red which means new record.
Else if, number exist then loop through columns. If the column content is different then the previos content, color that cell in yellow which means it is a modified data.