title: Use Conditional formatting to turn a cell Red, yellow or green depending on 3 values in another sheet
body: <p>I have a table with 262 rows and 52 columns of data(numbers). I want to set each one of the cells to a RAG(Red,Amber,Green) format(Conditional maybe). The cell needs to reference another sheet(new sheet) with 3 columns(A,B,C) and 262 rows.
  The formula for the 3 RAG values needs to look like:-</p>
  
  <p>if the value A100 &lt;= column A,B,C100(new sheet) then turn cell Green
  if the value A100 = or 10% greater than column A,B,C100(new sheet) then turn cell Amber
  if the value A100 = or 20% greater than column A,B,C100(new sheet) then turn cell Red</p>