title: Excel compare data from two sheets
body: <p>I have two pricing sheets I need to compare. There are 4 columns. Part number, description, percent discount and price.</p>
  
  <p>I need to compare the old sheet to the new to find any pricing and percent updates.</p>
  
  <p>Since the list of part numbers can add ore remove from sheet to sheet it could not compare by row and would need to do something like this.</p>
  
  <p>Look at first part number in sheet one. (old price list)</p>
  
  <p>Locate same part number in sheet two. (new price list)</p>
  
  <p>Compare percent and price and if different then highlight in sheet two.</p>