Comparing two sheets doesn't work

Question

I wanted compare between source and destination's hash values via csv excel for data integrity.

https://www.ablebits.com/office-addins-blog/compare-two-excel-files-sheets/

I'm studying with this article, especially in section below,

'Highlight differences between 2 sheets with conditional formatting'.

After following that,

I got "cannot use relative reference on conditional formatting",

Even if excel says nothing error, it cannot detect my dummy test cells which is intentionally set different.

Of course both files are running on same excel program, and even synchronous rolling works good as well.

Answer 1

After copy all the data into same sheet, use this formula to highlight the difference.

=B1<>E1

Answer 2

The rule even cannot be applied.

Mine is office professional plus 2019.

Can you guess why is this happening?

Answer 3

Copy your data to same workbook with another sheet.

=A1<>Sheet2!A1

Answer 4

No, I wanna know how to do, not only consequences.

Those test files are just 'test files', totally meaningless.

It would be glad if you let me know what is the cause and solution or alternative.

Answer 5

Official tool for Spreadsheet Compare.

Basic tasks in Spreadsheet Compare - Microsoft Support

Could you share us two test file without sensitive information? We may set the conditional formatting for you and send back the files.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.