Question: how to compare two tables in excel and highlight differences?
Answer: tool choose the main sheet and the one you'd like to compare. to it can be in a different file as you can see. we'll go ahead keep the default settings and click compare the edit will highlight all differences in green place the tables side-by-side. and that a small vertical toolbar to each of them.