title: Powershell: Filling current row with color in Excel Spreadsheet
body: <p>Been working with Powershell script which runs a loop against a bunch of machines and generates an Excel spreadsheet with the results using a foreach loop - would like to fill the color of a row based on a certain criteria. I don't have any PC's currently that meet this criteria so I cant test, wondering if someone could tell me if I have the code right in the last like to fill the current row.</p>
  
  <pre><code>$a = New-Object -comobject Excel.Application
  $a.visible = $True
  $b = $a.Workbooks.Add()
  $c = $b.Worksheets.Item(1)
  $c.rows($_).Interior.ColorIndex = 3
  </code></pre>