title: Conditional Formatting, using an formula to format based on different cell value range
body: <p>I'm trying to use a conditional format formula but I cannot figure out how to write it correctly.  Attached is an image of the data set that I'm working with.  <a href="https://i.stack.imgur.com/G7KGQ.jpg" rel="nofollow noreferrer">Dataset image</a></p>
  
  <p>Ideally, temperature values in column B will highlight red if they are out of their + or - 0.5 degree range based on which tank they are in. Previously I selected the individual cells that are associated with a specific tank to format based on the range (i.e. cell value not between =$F$4-0.5 and $F$4+0.5 then format red) but it is a pain to individually select each cell when the instrument changes tanks weekly.  </p>
  
  <p>Is there any way to tell it to format B6 based on D6 such that it uses the conditional format of "cell value not between =$F$4-0.5 and $F$4+0.5 then format red"?  </p>