The difference report can highlight cell differences, at the level of a single character, in the color red. This feature needs to be explicitly enabled by checking Color in red precisely the parts of formulae and text constants that differ available on the Options dialog.

Compare Excel cells (strings, formula, values) and show differences at character level
Previous Home Next