title: Excel Conditional Formatting: compare id description in sheet 1 to id description in sheet 2 if not a match highlight description in sheet 2
body: <p>we have two sheets sheet1 has ID, description, method and sheet2 has ID, description, method</p>
  
  <p>sheet1 contains such values:</p>
  
  <p>ID   Description   Method  </p>
  
  <p>1|a|z</p>
  
  <p>2|b|z</p>
  
  <p>3|c|z</p>
  
  <p>4|d|y</p>
  
  <p>sheet2 contains such values:</p>
  
  <p>ID   Description   Method         </p>
  
  <p>1   b        z  </p>
  
  <p>1   a        z  </p>
  
  <p>2   b        z</p>
  
  <p>3   c            z</p>
  
  <p>4   d            y</p>
  
  <p>4   a            y</p>
  
  <p>I need to match the ID in sheet 1 to the ID in sheet 2 and check to see if the Description in sheet 1  matches
  the description in sheet 2 else highlight the description in sheet 2. </p>
  
  <p>So far I can do a conditional formatter if the id is not in both sheets but I am not sure how to do a conditional formatter by matching the id and then comparing the descriptions such that if they do not match the description is highlighted in sheet 2. any help is greatly appreciated.</p>