title: Unable to change font color in excel using python xlsxwriter
body: <pre><code>workb = xlsxwriter.Workbook('Newexcel1.xlsx')
  worksheet1 = workb.add_worksheet("Sheet 1")
  
  for row, row_data in enumerate(alldata):
      worksheet1.write_row(row + 1, 1, row_data)
  
  cell_format.set_font_color('vbRed')
  
  
  worksheet1.conditional_format('C2:C7', {'type':     'cell',
                                      'criteria': '==',
                                      'value': 'Data Matched!',
                                      'format': cell_format})
  </code></pre>
  
  <p>I'm trying to write to an excel file using python. The <strong>alldata</strong> is list of lists. The problem is that i want to change the color of text in Data Matched to green and Not Matched! to red, which is not happening. The code listed above doesn't show any error but when i open the excel file it asks me to restore previous version as the new one has xml error.</p>
  
  <pre><code>alldata =     [['My Total', 'Data Matched!', '$824,499,658', '$824,499,658'], ['Second Total', 'Data Matched!', '$824,532,682.20', '$824,532,682.20'], ['Featured Articles', 'Data Matched!', '$391,153,610.55', '$391,153,610.55'], ['Ads Revenue', 'Data Not Matched!', '$825,513,740.17', '$825,582,419.92'], ['Company 1 Revenue', 'Data Not Matched!', '$824,765,286.03', '$824,833,965.78'], ['Company 2 Revenue', 'Data Not Matched!', '$176,767,751.61', '$239,939,801.89']]
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/zitFZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zitFZ.png" alt=""></a></p>
  
  <p><a href="https://i.stack.imgur.com/U6MnG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U6MnG.png" alt=""></a></p>