title: How to fill the color in cells A1:A5 and B1:B5 and C1:C5 with the same color using C#?
body: <p>I am currently using the following code to fill cells in the range A1 to A5, and B1 to B5, with yellow:</p>
  
  <pre><code>chartRange1 = xlWorkSheet.get_Range("A1", "A5");
  chartRange1.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow);
  Excel.Range chartRange2;
  chartRange2 = xlWorkSheet.get_Range("B1", "B5");
  chartRange2.Interior.Color= System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow);
  </code></pre>
  
  <p>But it takes 2 <code>chartRange</code> objects in order to do this. What if I want to set the same color over a wide range of cells?</p>
  
  <p>Is there a way to do this using a single statement that sets the same color for a larger range of cells?</p>