Hi all,
I have a table with two columns with the title A and B.
In each column I have integer values.
Now I want to apply following rule: If the sum of column A is greater than 0, the color of the column title should be yellow after the export. The same for column B.
I know there are XLS-Formatter but it was quet hard for me to apply the rule…can I do it in KNIME?
Kind regards. T2H
Hi @Time2Hire
I don’t have an elegant solution available, but maybe this works for you?
20608.knwf (28.4 KB)
The key idea is to map the sum to a color string (e.g. “#FFFF00”) depending on its value. Formatting is applied using the XLS-Formatter nodes you mentioned.
Kind regards
Marvin
Wow, that was really helpful! And it works!! Thank you so much!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.