Conditional Formating - Highlight Differences Across Multiple Columns

[kijjet]

I have been searching and searching and I can't seem to find anything that works. I've tried what feels like 800 different ways, based on other threads I found, but none seem to work. Any help you can offer is appreciated!

Background:
I am using Excel 2010. I want to compare two different versions of a quote (ie: "V1" & "V2", V for version) and highlight any differences in product code and price. It is further complicated because product codes are often added or deleted from "Version 2" of the quote, making the rows not line up correctly. (Because I don't know a better way), I've created a macro that does a simple "Insert" on any cells I have selected (ie: Right Click > Insert...). That allows me to realign the two versions. However inserting new cells does a number on any conditional formatting I have applied. I would like help determining the best way to highlight differences in the data, that will still work (or can easily be reapplied with a macro) after the data is realigned.

Here is some sample data:

V1_Product	V1_Product_Price	V1_Service_Price	V2_Product	V2_Product_Price	V3_Service_Price
Console	100	100	Console	150	100
Drives	100	100	Drives	100	50
Nodes	100	100	Nodes	100	100
Cables	100	100	Software	100	100
			Cables	100	100

<tbody>
</tbody>

In my current setup, I would manually realign V1 so the Cables entry & associated prices would be in A6:C6, A5:C5 would be blank (newly added) cells. I would love to know if there's a non-manual way to realign (without sorting because the order of the Product is significant). I would also like to know how to conditionally format the columns so any differences between V1 and V2 are highlighted. In the example above, I would expect to see cells B2 and E2 highlighted and C3 and F3. Also, once V1 was realigned so the Cables entry was in cells A6:C6, I would expect to see cells D5:F5 highlighted to show that Software is a newly added item.

Thanks in advance for any guidance you can give.