title: Conditional formatting based on another cell's value in Google Sheets
body: <p>Fairly basic question but I cannot seem to figure out what the problem is!</p>
  <p>I am looking to use conditional formatting to colour a figure red or green depending on whether it is under or over he target which is set in a cell. There is the possibility of the target changing so I am keen to not include the target figure in the conditional formatting iteself.</p>
  <p>In the below example I have the conditional formatting set to show in columns F-W if the figure is less than the figure in E change to green.
  In the highlighted (2nd set of data) you can see that column L, U &amp; W are all less yet they are not green and that column G &amp; J are more than yet they have turned green!</p>
  <p><a href="https://i.stack.imgur.com/REeXA.png" rel="nofollow noreferrer">Example data</a></p>