Hi,

I am a newcomer when it comes to functions and programming in Excel which
makes this task all the more difficult. I have a worksheet that is updated
continuously with new/added information and information that is deleted.
This is an inventory worksheet with retail items listed in rows and aspects
of its description located in adjacent cells. Basically, I cannot depend on
an item to be located in the same row each time the worksheet is updated
since things are added and deleted.

What I would like to do is have the original (non-updated) worksheet be
compared to the updated worksheet by:

1. Using the info starting from C3 down (the UPC number for the product) in
the original worksheet and search for this number in the same column (C) in
the updated worksheet.

2. Highlight any differences in columns G, H, I, for the row in question
where the identical UPC numbers are found in both worksheets. (Highlighted in
the original worksheet)

This is a very involved task I would assume, so if an answer cannot be
provided, I would certainly appreciate any suggestions regarding reference
material. Thank you for your time

Glenn Yamada