Compare two large Excel sheets for changes to data and highlight the differences

I need to track changes in two large Microsoft Excel sheets, and then highlight the differences in the second sheet. The two sheets may have different numbers of rows and may also be in different orders, but each row will have a unique identifier. As such, I chose to use vlookup, to compare rows with unique id's. However, when I use vlookup with conditional formatting, I can make it work for the first column only. When I use the Format Painter button to clone the the formatting horizontally. The Format Painter works for all of the variables, except the column number. And since there are over 100 columns, it would take forever to format each column individually. My question is two fold: Is there a trick to making the format painter work horizontally. Or is there a better way to accomplish what I'm trying to do?  Attached is a paired down version of my excel file.
compare-ee.xlsx