Exporting coloured (or colored) cells

Hi, I'm quite new to KNIME but getting to grips with it now. However, I really like to see data with colour conditional formatting applied (as in MS Excel), more specifically as a 3 colour formatting on each column (for example, if less than 50 make the cells green, 50 to 70 make the cells yellow, and greater than 70 make the cells red). Myself and a number of other colleagues all like to be able to do this as its visually impactful in presentations. When I export from KNIME using the XLS Writer node there seems no option to do this and I therefore have to keep manually doing this in Excel every time I export data. Am I missing something, is there a way to do this in KNIME, so the output to Excel is already coloured.

Thanks, Simon.

1 Like