As you already know xlCompare has as less options as possible. This is one of the principles of the our software. You should not spend your time deciding which option to select. xlCompare should do it for you.
However, you may want to use different comparison strategies:
You want to get all differences in the worksheets. This strategy means, that you want to get complete list of differences - if
somthing different is found between cells - this should be reflected.
We call this comparison strategy - strict.
Get only actual changes done by user. This option needs more explanation. Imagine the following:
You have 2 formulas:
You can change comparison strategy using menu command:
Compare | Options | Strict (Smart)
By default xlCompare uses Strict comparison strategy - find all differences and do not filter them.