Replace data in a table with same data from another table, bringing formatting with it.

I am working on an inventory price change list. The list had over 6K items on it from inventory additions over the life of the company. I wanted to fix the prices of the currently used items first to get the "important" items done, so that I can go back and fix the "unimportant" ones later. I pinged the inventory list for things sold/ordered in the last three years and reduced the list to 780 items. So I have sheet1 that has the full 6000 item list, and sheet 2 which has the 780 "current" items. I went through the "current" items and fixed all the prices and as I was fixing them, I changed the text color to orange so I could track which ones had been fixed in the accounting software. Now, I want to replace the items in the long list with the same items from the short list, but keep the orange text formatting when the data comes in. Is there a formula, or a VBA code to do what I am trying to accomplish? EX:

Original Short (In Orange)
Item: Desc: Item: Desc:
703 Wall mount Siren 747 Wall Mount Siren
712 Flush Mount Siren 814 Ceiling Mount Horn Strobe
747 Wall Mount Siren
800 Surface Mount Horn Strobe
814 Ceiling Mount Horn Strobe


So I want the items from the Short list to replace themselves on the long list and carry the orange text (747 and 814 on the long list become orange text) so that I can see on the long list, what's been done and what hasn't, OR, if I can use it to delete the short list items off the long list, that would serve the same purpose. I thought about using 'remove duplicates' but I'm not sure if I can designate "remove the ones without formatting" or if it just deletes the first one or what... Thank you for any help you can offer.

You might try this:
Highlight the row with your part numbers in the long list
Go to Conditional formatting > highlight cells rules > Formula
Input the following formula:
=lookup(first cell,Sheet2!(parts # Column(i.e. $H:$H)=first cell
format to change cell fill and or font formats
Click OK

That should get you what you're looking for.

Hope that helps.

-Z

I used VLOOKUP to update the pricing.