Highlight match old and new SKU from two columns and change price

[juno612]

Hi Guys

Thank you in advance for you guys' help

We are currently working on uploading product (XML) to our website, we have some old product data done and now there are some new product sheet came out and we have 30 of them. Between the new and old product sheet, we have to add new products, remove discontinue products and update all the old product's pricing.

First come to first, we need to find out which are the old products and which are the new products. Yes, the manufacture didn't separate the new from the old. I have put together a sample Excel, please see attachment.

I need to compare them and highlight the cells in in GREEN on both columns when they are match.
Column A (Old SKU)
Column B (New SKU)

Column C (New COST)
Column D (New MSRP)
Column E (New SPECIAL PRICE)

Update new pricing from NEW Columns C,D,E to OLD Columns F,G,H when the cells from Column A and B are highlighted
Column F (Old COST)
Column G (Old MSRP)
Column H (Old SPECIAL PRICE)

Can that be done within Excel build in functions? Please Please Please help, that will save me hours of manual work.

Truly Appreciate,

[humdingaling]

what do you actually want excel to give you?
highlighted rows when A&B are the same?
something like this?

[juno612]

That's exactly what I need, the unselect on the column A is discontinued items and the column B is a new items. Also the selected items which is the old items' price have been update.

Thanks a lot.

[juno612]

By the way, I see the formula on the price changing columns. How about the highlighting functions? Where is the formula or module?

Thanks

[juno612]

Oh, once I changed the sku, then the highlight is gone. Just curious, how can a forum "=IF($A12=$B12,C12,"")" can perform so many functions all at once? Is there any other programming or excel built-in functions involve with the job. The reason I am asking is, may be I need to move it to other excel. If there is a hidden functions, then the formula may not work.

Frank

[humdingaling]

Formulas in columns J to L are just formulas
the highlighting is done by conditional formatting

the formula i used for this conditional format is
=$A2=$B2

and i made it apply to this area
=$A$2:$H$32

a little reading on what conditional formatting is
http://www.techrepublic.com/blog/mic...tting-feature/

if you want to learn more about this...there is plenty of stuff on youtube you can google
its hard to explain step by step in words when alot of it requires point and click

[juno612]

Humdingaling,

Thank you very much and truly appreciate your time and patient. Again, love people from this forum

Best Regards

[humdingaling]

not a problem

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Cheers
hum

[juno612]

Just did