title: How to do alternate row shading using Office.Interop.Excel?
body: <p>I'm using Office Interop via C# 4.0 to write an Excel file. I would like to shade alternating rows. I know how to do this with the GUI in Excel. I could also loop through each row to provide the shading, but this option is unacceptably slow with large data sets. Is there a way, using Office.Interop.Excel to set the conditional formatting options found in the Excel GUI?</p>
  
  <p>EDIT: Added more information</p>
  
  <p>Using C# with .NET 4.0 and Office Interop 2007</p>