title: Conditional Formatting in Google Sheets where Percantage Range is Involved
body: <p>I am trying to figure out how to do conditional formatting on a range of percentage in google sheets.</p>
  
  <p>I want to fill the cell in question a certain colour depending on how much the percentage is of another cell.</p>
  
  <p>I have learned out to do this for higher than 80% (red fill) and lower than 40% (green fill) but can't work out how to do it between 40% and 80% (in which case I'd want the fill to be Amber).</p>
  
  <p>I have attached a screenshot of how I thought it should go but it's not working. </p>
  
  <p>I'm sure i'm missing something really obvious but I can't work out what. Could someone please help?</p>
  
  <p><a href="https://i.stack.imgur.com/dlaVK.jpg" rel="nofollow noreferrer">Screenshot</a></p>