title: Macros to compare shop name and Invoice Number between two sheets and highlight matches
body: <p>Hi Guys I am not sure if the code for this is already given I tried similar questions but I didnt find an appropriate solution so I am asking this here</p>
  <p>&quot;Note: I use Office 2010 only&quot;</p>
  <p><strong>The Problem:</strong></p>
  <p>I have two sheets in excel with the entries like Tin No, Customer Name, Invoice Number, Cost, Tax, Value before Tax, Value after-tax, etc., Now I have to compare both the Customer Name and Invoice Number in both sheets and return the value or highlight the results.</p>
  <p><strong>The Situation</strong><br />
  (Sheet 1)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customer Name</th>
  <th>Invoice Number</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Carpenter</td>
  <td>101</td>
  </tr>
  <tr>
  <td>Painter</td>
  <td>102</td>
  </tr>
  <tr>
  <td>Courier</td>
  <td>103</td>
  </tr>
  <tr>
  <td>Welder</td>
  <td>104</td>
  </tr>
  <tr>
  <td>Painter</td>
  <td>105</td>
  </tr>
  <tr>
  <td>Courier</td>
  <td>106</td>
  </tr>
  <tr>
  <td>Welder</td>
  <td>107</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>(Sheet 2)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Customer Name</th>
  <th>Invoice Number</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Carpenter</td>
  <td>101</td>
  </tr>
  <tr>
  <td>Courier</td>
  <td>103</td>
  </tr>
  <tr>
  <td>Welder</td>
  <td>104</td>
  </tr>
  <tr>
  <td>Painter</td>
  <td>105</td>
  </tr>
  <tr>
  <td>Welder</td>
  <td>107</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>In Sheet 2 Invoice numbers 102 and 106 are missing I want that Highlighted in a separate column or in the same sheet with a different color.</p>
  <p>If it is still not clear please let me know.</p>