Conditional Formatting

Hello @LOEM,

We'd recommend you using an Excel template instead of DOCX template.

You can define a background color of a cell in the Excel table based on a value.

Please check out a detailed instruction on how to set this up in excel file in this article.

So, to sum this:

  • prepare an Excel template with the table, tags and formulas to change the color.
  • fill the template and after opening the result file, the formulas should apply the colors to the cells.

Best regards,
Petr
Plumsail team