First time poster, long time reader!
I am using libxlsxwriter in C.

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.

the problem is that only the later is applied to each sell. so if do:

```
    worksheet_set_column(bla, bla, bla, date_format)
    //later in a loop:
    worksheet_set_row(bla, bla, bla, green_format).

```

the cells will only have the green\_format but the the date\_format

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.

Is there a better way?
Thanks!