Conditional Formatting to highlight differences between two sheets with the same table.

Example.xlsx

Hello,

Background: I manage a variety of contracts with several operators, I use a weekly report and I want to compare differences between the two instantly. I currently have a COUNTIF conditional formatting rule which highlights contracts that have ended and new contract entries, but I'm struggling to use conditional formatting to highlight when a contract has been removed from one operator and given to another.

I have attached an example, showing the sort of highlighting I am looking to put in place. Look forward to hearing from you guys, you have proven very helpful in the past.

Arthur.