Conditional formating two reports for differences

I am new to this forum as I am trying to find an easier way of balancing two reports from two different systems for discrepancies.
For the last days I have been stuying conditional formating but the more I read the less I understand, my excel knowlegde is pretty basic

I need to compare the batch number and the amount booked. Plus I need to check if it's booked in the correct office (EU,US etc)

Is there a way to do this balancing by Excel with some clicks instead of ticking them off by hand?

Thanks for all your help :-)