Compare Price List

Please see the sample done manually.

What i am trying to do here is the following:-

1. Looking the values is repeating within the same sheet i.e. old list.
2. Looking the values is repeating within the same sheet i.e. new list.
3. Looking the values is appear in both the sheets i.e. old list & new list.

I hope this is make clarification of the issue.