title: Matching two sets of data for highlighting
body: <p>I have two positive values in columns A1:B1, and a small table
  on D1:H2 on the same spreadsheet. I'd like to use a formula to conditionally
  highlight the values of A1:B1 on the table (if they're present).
  I tried to do this using match, and hlookup, but I couldn't make it work.
  I'd be glad if you could give me a little help.</p>
  <p>sample data:</p>
  <pre><code>A : B       D   E   F   G   H 
  1   5       1   3   5   7   9
              2   4   6   8   10
  </code></pre>
  <p>So the result'd be like this with conditional formatting:</p>
  <p><a href="https://i.stack.imgur.com/hxuBP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hxuBP.png" alt="enter image description here" /></a></p>