Comparing sheets for changes

I'm relatively new to Excel, and I've been scratching my head at a problem. I get a daily list of changes to engineering reports and I need to compare them with the previous days to log changes for my team. I tried using an IF function and conditional formatting, but the report frequently has rows added or dropped as engineering reports are closed and opened, so it was flagging over half the sheet as new changes.

I've had some success with Power Query but if a single cell changes, it flags the entire row for me. I only learned Power Query in the past week so it's entirely likely my issue is in merging the charts incorrectly. Any advice would be much appreciated.