title: Excel - Shading entire row based on change of value
body: <p>I would like to shade entire rows in Excel based on the value of one cell.  For example say I have the rows below:</p>
  
  <pre><code>**File No**
  1122
  1122
  1144
  1155
  1155
  1155
  1166
  </code></pre>
  
  <p>I would like the first two rows (where the value of the file # is 1122) to be shaded in color 1, the next row (where the value of the file # is 1144) to be shaded in color 2, the next 3 rows (where the value of the file # is 1155) to be shaded color 1, the next row (where the value of the file # is 1166) to be shaded color 2</p>