title: Highlight Rows in an excel document
body: <p>Is there a way to highlight/fill the cells in row x a given colour from a visual basic application? I can read and write to cells but can't find syntax to format cells or entire rows if possible.</p>
  
  <p>Edit:
  code for Read/Write</p>
  
  <pre><code>Dim APP As New Excel.Application
          Dim worksheet As Excel.Worksheet
          Dim workbook As Excel.Workbook
          workbook = APP.Workbooks.Open(InputFile)
          worksheet = workbook.Worksheets(1)
  </code></pre>
  
  <p>Read:</p>
  
  <pre><code>Arr(i, 0) = worksheet.Cells(rowcount, 14).value
  </code></pre>
  
  <p>Write: </p>
  
  <pre><code>worksheet.Cells(row, Col).value = Arr(i, 2)
  </code></pre>