Help Comparing cost on two work sheets to update cost

[mbechtel]

I am trying to figure out how to update cost from a vendors .xls file I want to compare my price list to the vendor price list by OEM number and Highlight any cost that have changed and show the amount of change. I have really tried and tried but I cannot figure out how to do the formula correctly. Any help would be greatly appreciated as I have to do this manually now and we have 4000 parts from this particular vendor.
Thank You
Matthew

[mdbct]

You can do this using conditional formatting. I've attached a sample workbook (I can't demonstrate using your file - I do not have Excel 2007).

[mbechtel]

Sorry I do not really understand your explanation or how to apply it. I changed the format of my example to an xls

[mdbct]

I've updated the sheet. To compare the costs I used the VLOOKUP function:

Please Login or Register  to view this content.

To highlight the cell, I used contional formatting of:

Please Login or Register  to view this content.