title: Google Sheets - How to highlight cells in a row that match values from other cells?
body: <ul>
  <li>I have a row of values (say 1-10)</li>
  <li>At the beginning of the rows I have 2 numbers generated from dates from other cells that represent week numbers. (eg, 3 and 9)</li>
  <li>I want my row to highlight all the numbers from 1-10 that are between the values from the week number cells. (eg the cells with numbers 3,4,5,6,7,8 and 9 will automatically turn a colour (say green))</li>
  </ul>
  
  <p>I've tried the conditional format, using the "between" values.
  It doesn't work. </p>
  
  <p>If I just type the numbers into the format box, it will work, but the problem is I need it to refer to the value in the cell NOT a number I type in, because there is a likelihood that the dates could change, which will affect the value shown in week number cell, so I need it to work automatically and not require me to go through every single row changing values for the formatting.</p>
  
  <p>Is this even possible on sheets?</p>
  
  <p>Thanks in advance, I am hoping I've just overlooked something simple.</p>