title: Coloring excel cells based on percentiles
body: <p>I'm not sure if this is the correct forum for my question, but if it isn't, I'd appreciate it if someone could tell me where to direct it.  My question is specific to excel. I have a range of data which I would like to color according to percentile. </p>
  
  <pre><code>1385
  5133
  6001
  4407
  4846
  5621
  6018
  8328
  4904
  8054
  6401
  7976
  1326
  8628
  5690
  8218
  </code></pre>
  
  <p>for example. </p>
  
  <p>What I would like to do is color each cell based on its percentile ranking. I want to make the color scheme graduated; that is, the 99.999th percentile should be on the violet end of the color spectrum, while the .00001th percentile should be on the deep red end of the color spectrum. </p>
  
  <p>I recognize that this may be a fairly complicated problem, but I assume it's a pretty common one.  </p>