title: libxlsxwriter multiple formats on a cell
body: <p>First time poster, long time reader!
  I am using libxlsxwriter in C.</p>
  <p>I want to color rows either green or red and give the columns a different format each (which is either a date, a 2 decimal number or a 7 decimal number, or default.</p>
  <p>the problem is that only the later is applied to each sell. so if do:</p>
  <pre><code>    worksheet_set_column(bla, bla, bla, date_format)
      //later in a loop:
      worksheet_set_row(bla, bla, bla, green_format).
  </code></pre>
  <p>the cells will only have the green_format but the the date_format</p>
  <p>is there a way to apply both?
  I have a very messy solution where i just make red and green variation of each format, i.e. date_green_format/date_red_format. but that is really messy and i would like to avoid it aat all cost.</p>
  <p>Is there a better way?
  Thanks!</p>