All my product's SKU and prices are in an Excel document in different columns (Sheet1). In the same spreadsheet, but on another worksheet (Sheet2), I have distributor data with product SKU and prices.
Format
Sheet1 | A = sku, B = product price Sheet2 | A = sku, B = product price
I'm looking for a way to compare all the prices in Sheet1 with the prices in Sheet2. If the prices are not the same, the field should be green.
The SKU number never changes.
Can anyone point me in the right direction?