We have two sheets, Sheet1:
Both sheets have approximately the same amount of data, but there are differences. I want to match IDs between Sheet1 and Sheet2 and highlight any differences on Sheet1 found in the corresponding row, like so:
My attempt at the conditional formatting logic is as follows: Do a lookup on A2 of Sheet1 in the A column of Sheet2 and if there is a match, compare Sheet1's B2-E2 to the B-E match of Sheet2. Move to the A3 of Sheet1 and repeat.