title: Excel Conditional Formatting Percentile Range
body: <p>I have a list of 100 students each with different scores
  I would like to highlight the cells according to the following table:</p>
  
  <pre><code>0th to 20th percentile: Green
  20th to 40th percentile Blue
  40th to 60th percentile Purple
  60th to 80th percentile Yellow
  80th to 100th percentile Red
  </code></pre>
  
  <p>Note: Percentile NOT score</p>
  
  <p>Currently Excel only allows me to highlight the top x% and bottom x% of the students, nothing in between.</p>
  
  <p>How do I do that?</p>
  
  <p>It will be good if I can highlight both column A and B based on the values in column B</p>
  
  <p><a href="https://i.stack.imgur.com/41DKL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/41DKL.png" alt="enter image description here"></a></p>