title: Match cell values across two sheets in same worksheet
body: <p>I have two sheets in one google doc.</p>
  <p>They both contain product codes, one has 3427 product codes, and the other has 1205 product codes. The sheet with the 1205 codes is the newer one, and I'd like to compare the two sheets for matches. They are both in column A.</p>
  <p>So, in sheet one, I want to highlight all matches with sheet two.</p>
  <p>The reason for this is that sheet a has ALL product codes stored on our internal systems, even expired products. List two has only our current products. I want to highlight our current range in sheet one, so I can quickly delete the old items.</p>
  <p>The full sheet which i have not linked has a lot of data that does not match across the two.</p>
  <p>Here is what it looks like: <a href="https://drive.google.com/file/d/1f_4t7m2NmEFu2YbT_-VAwn_o9WHk45Sr/view?usp=sharing" rel="nofollow noreferrer">https://drive.google.com/file/d/1f_4t7m2NmEFu2YbT_-VAwn_o9WHk45Sr/view?usp=sharing</a></p>