Compare worksheets for data Changes

[novacrsh]

Hello,
I am very new to excel and would appreciate anty help on the following issue.
I receive a report every 15 minutes which displays a catalogue number and the number of units required on "live" orders. This data changes every 15 minutes (additional articles and/or units required). I need to be able to compare these reports/worksheets for new data which idealy would be hilighted by excel.
Many thanks in advance

[rwgrietveld]

This Excel can do very well for you, but I need to see the data.

Please upload a small part of the current and the previous data.

Cells A1 till F20 for both sheets would be fine.

[novacrsh]

Thank you for your quick response
Please find Report 1 and report 2 attatched.

[rwgrietveld]

I had to copy the previous data into the current data sheet as Conditional Format does not work between different Workbooks. I think the attached sheet will give you better understanding of the formala used:

Please Login or Register  to view this content.