Exclude error values from comparison

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:
It enables the option you need. When cells are compared, error values are skipped.