title: Programmatically adding conditional formatting in Excel 2007
body: <p>I want to use conditional formatting feature of excel 2007 programmatically. I have following scenario.</p>
  
  <p>I have 6 columns of numbers</p>
  
  <pre><code>A   B  C  D  E  F
  100 25 25 15 20 50
  ....
  </code></pre>
  
  <p><code>if (C1/A1)*100 &gt;= B1</code> I have to color it as red. The same rule applies to D1, E1,F1 columns.</p>
  
  <p>I saw conditional formatting feature in excel 2007. But I want some pointers on how to implement it in C# code.</p>