title: Comparing Columns and Highlight the Matching Data Using Excel VBA
body: <p>I Need to compare <code>Column B</code> in <code>Sheet 2</code> with <code>Column C</code> in <code>Sheet 3</code> and highlight the cells with matching data in <code>Column B (Sheet 2)</code>. </p>
  
  <p>Have used the following formula in <em>Conditional Formatting</em> </p>
  
  <p>which works <code>=NOT(ISNA(VLOOKUP(Sheet3!C,Sheet2!B,1,FALSE)))</code> with Format type being a </p>
  
  <p>particular color say Yellow <code>Interior.colorindex = 6</code></p>
  
  <p>How to implement the same using code in VBA?</p>