title: Conditional formatting google sheets, match date between two dates- mark that row that is matching
body: <p>I am looking for a way to match any date in a column of dates with a bunch of start/end periods at columns next to it. If any match, mark my cell.
  I have managed to do this for one row, but I would like it to look at a whole column (or set range ex X6-X10) and compare with a bunch of date-periods in two columns.</p>
  <p>Any one with any ideas of how I can do that?</p>
  <p>This is what I have come up with so far:
  <a href="https://i.stack.imgur.com/fvH4x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fvH4x.png" alt="enter image description here" /></a></p>
  <p>And I am using this formula:
  <code>=AND($X$6&gt;=$R$6,$X$6&lt;=$T$6)</code></p>
  <p>But, as I said, this only works for one row today. I would like to look through all rows in the columns.</p>