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

Could you share your workbook to me?

Answer 3

I'm glad for your help.

I've just received your test file,

I tried to mimic your command in my local file, but even it's same command, my laptop doesn't work for that.

It says again, 'cannot use relative reference on conditional formatting'

All the sequences and meaning are same with English does

Answer 4

I have sent my test workbook to you via private message.

You may copy value only to that workbook.