VLOOKUP Function and color coding

Team,

I have two sheets EDW1, EDW2. Please find the same attached.

EDW1 has less records where as EDW2 has more records.

In Comparison Sheet, I need to compare EDW2 with EDW1 results (Basically the value is ADD)

Steps to follow

1) Group the duplicate values in EDW1 (Do not consider Order ID)
2) Group the duplicate values in EDW2 (Do not consider Order ID)
3) Now Compare EDW2 with EDW1 sheet
4) The matched records should be highlighted with Green
5) Extra records in EDW1 should be highlighted with RED
6) Extra records in EDW2 should be highlighted with Blue

Please do let me know if I am not clear

Thanks!
Kiran