Formula to check for Discrepencies

[numberonetwin]

is there a formula to check a sheet vs a master sheet and highlight the discrepancies?

 

[VoG]

Something like

=IF(Sheet1!A1=Sheet2!A1,"","Discrepancy")


but more information needed.

 

[numberonetwin]

such as the whole sheet, not just specific cells to simplify the matter

if the sheet sent back to me by another person does not match the original, is there a way to highlight where it does not match?

 

[numberonetwin]

or is there a formula that one could just add to a sheet that would compare it to a sheet with the exact same formatting and hightlight the differences