title: How to change the background color of an Excel report
body: <p>Basically, I am using this script to run through all the <code>.csv</code> files in a specific folder and merge them all together. But after the merge, I still want to change the background color of each <code>.csv</code> file.</p>
  
  <p>The script that I got so far does not do that, can't figure out how to do it as I am really new in PowerShell.</p>
  
  <pre><code># Get all the information from .csv files that are in the $IN_FILE_PATH skipping the first line:
  $getFirstLine = $true
  
  get-childItem "$IN_FILE_PATH\*.csv" | ForEach {
      $filePath = $_
  
      $lines = $lines = Get-Content $filePath
      $linesToWrite = switch ($getFirstLine) {
          $true { $lines }
          $false { $lines | Select -Skip 1 }
      }
  
      # Import all the information... and tranfer to the new workbook.
      $Report_name = $((get-date).ToString("yyyy.MM.dd-hh.mm"))
  
      $getFirstLine = $false
      Add-Content "$OUT_FILE_PATH\Report $Report_Name.csv" $linesToWrite
  }
  </code></pre>
  
  <p>e.g. The <code>.csv</code> file has this pattern:</p>
  
  <blockquote>
  <pre><code>Name        Age
  
  Richard     18
  Carlos      20
  Jonathan    43
  Mathew      25
  </code></pre>
  </blockquote>
  
  <p>Making sure to understand that Richard (18 years old) and Carlos (20 years old) are from <code>filenumber1.csv</code> - Jonathan (43 years old) and Mathew (25 years old) are from <code>filenumber2.csv</code></p>
  
  <p>I want Carlos' and Richard's rows to be with a white background, whereas Jonathan's and Mathew's rows to be grey. So that repeats in white-grey-white-grey dividing it by each file.
  I am trying to make it more friendly to observe the report in the end - to make sure that you can this separation from file to file more clear.</p>
  
  <p>Any ideas?</p>