Compare Ranges with vba

[bjc124]

I'm looking for a solution to compare 2 ranges of data. I'd like to find a vba solution if possible.

I'd like to compare the data in F6:J50 with the data in A6:E50 and if there is anything missing or that doesn't match be highlighted in the Light Red (Bad Cell Format) color and if there is anything in A6:E50 that isn't found in F6:J50 be highlighted in the neutral Yellow cell format.

If I'm going about this all wrong and there's another much simpler way of executing this by all means please set me straight. I've included a sample spreadsheet with example data for someone to play with.

I did experiment with the compare cells function of Kutools and while it worked and did pretty much what I wanted the process was extremely slow.