Question: how to compare two tabs in excel and highlight differences?
Answer: Highlight differences between 2 sheets with conditional formatting. To highlight cells that have different values in two sheets with the color of your choosing, use the Excel conditional formatting feature: In the worksheet where you want to highlight differences, select all used cells.