title: How do I change the Text Color and the Fillcolor
body: <p>How do I change the header font color to white and the fill green?  These are the classes that I am using:</p>
  
  <pre><code>import static org.apache.poi.ss.usermodel.CellStyle.*
  import static org.apache.poi.ss.usermodel.IndexedColors.*
  import org.apache.poi.hssf.usermodel.*
  import org.apache.poi.hssf.usermodel.HSSFWorkbook
  import org.apache.poi.ss.usermodel.Cell
  import org.apache.poi.ss.usermodel.CellStyle
  import org.apache.poi.ss.usermodel.Row
  import org.apache.poi.ss.usermodel.Sheet
  import org.apache.poi.ss.usermodel.Workbook
  import org.apache.poi.ss.usermodel.Font
  </code></pre>
  
  <p>And this is the code where, I believe, it will have to be inserted into.</p>
  
  <pre><code>Font headerFont = wb.createFont();
  headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD)
  CellStyle headerStyle = wb.createCellStyle()
  headerStyle.setFont(headerFont)
  
  cellMOPID.setCellStyle(headerStyle)
  cellType.setCellStyle(headerStyle)
  cellStatus.setCellStyle(headerStyle)
  cellState.setCellStyle(headerStyle)
  cellStartDate.setCellStyle(headerStyle)
  cellEndDate.setCellStyle(headerStyle)
  cellDesc.setCellStyle(headerStyle)
  </code></pre>