title: How to format rows to color group by like values in column 1
body: <p>I have a worksheet that has information like this:</p>
  
  <pre><code>a
  a
  b
  c
  c
  c
  </code></pre>
  
  <p>How do I format it so that all of the rows that have a value of <code>a</code> in the first column are one color, then all the rows that have a value of <code>b</code> in the first column are a different color, etc. ?</p>
  
  <p><em>Edit not from OP to add clarification from comment:</em>  </p>
  
  <p>Everything is already sorted alphabetically, and will stay that way, and I want multiple colors.</p>