Spreadsheet Compare Output

1.Spreadsheet Compare is a tool in Microsoft Office for comparing differences in the contents of two Excel files.
It helps you identify differences in cell values, formulas, formatting, and more.
2. Open Spreadsheet Compare tool: Click “Compare Files”, select the two Excel files to be compared.
Click “OK” to start the comparison. 
3. Understanding the output: After the comparison is complete, the tool will generate a comparison report, showing the differences between the two files.
Differences will be marked with color, for example: red: different values.
Blue: different formulas.
Green: different format.
4. Export comparison results: In the Spreadsheet Compare tool, click “Export Results”.
Select the export format (Excel file) to save the comparison results for further analysis.
5. Check the file content: Ensure that the content and structure of the two Excel files are similar so that the comparison tool can correctly identify the differences.
If the file structure is very different, you may need to manually adjust it before comparing.
6. Use other comparison tools: If the Spreadsheet Compare tool does not meet the requirements, try other third-party comparison tools (Beyond Compare, DiffEngineX, etc.).
7. Contact Microsoft Support: If none of the above methods work, it is recommended to contact Microsoft support team with detailed error messages and screenshots for further assistance.

It will give you a summary of the differences, such as which rows have been added, deleted, or changed, but typically in a more technical format rather than visually highlighting them directly on the original sheets.

After exporting the results, you can manually review the "Export results" sheet and highlight discrepancies directly in that sheet using Excel's conditional formatting and filtering features. Use In-built functions like COUNTIF, IF, or VLOOKUP to cross-reference rows in both sheets against the results from Spreadsheet Compare.