title: Excel color scale based on alphabetical order
body: <p>I like Excel's color scale feature in the Conditional Formatting menu and I am trying to get it to work for text values. </p>
  
  <p>The way it works for numerical values is that it color-codes the lowest and highest values each with a certain color and then any values in between form a gradient between the min and max colors.</p>
  
  <p>I'd like to be able to do this with text based on the alphabetical order. So let's say I have a table of:</p>
  
  <pre><code>AT  ANY BOY CAT
  BAT CAT DAD AT
  </code></pre>
  
  <p>"ANY" would be the lowest value and "DAD" is the highest. I've applied the color scale to the table but none of the cells get colored. It seems like the values need to be numerical for a color scale to work. Is there a way to make this work? I'd rather not dive into any VB macros.</p>
  
  <p>Using Excel 2010</p>