Ignore cells with error values

If your workbook has cells error values (#REF!, #NA, ...) you may want to exclude them to make comparison results more clear. To put focus into actual changes.
Ignore Error Values command is located on the Filter tab on the ribbon:
Ignore Error Values
It enables the option you need. When cells are compared, error values are skipped.