Pivot table conditional color formatting

KNIME Analytics Platform
1

Hi colleagues, I am new to KNIME, trying to shift from Python Pandas to KNIME.

I am trying to apply conditional formatting
KNIME WF OUTPUT.xlsx (1.3 MB)
to the pivot table in knime. I know I have to use the XLS Conditional formatter however it does not take the pivot table type. How can I keep both row names and column names, and format only values with conditional formatting?

Screen Shot 2022-03-18 at 10.58.12 AM
Screen Shot 2022-03-18 at 10.58.12 AM1920×1000 373 KB

The data and sample workflow are attached. Thank you
KNIME_project 1.knwf (42.4 KB)
KNIME WF OUTPUT.xlsx (1.3 MB)

2

I know I have to use the XLS Conditional formatter however it does not take the pivot table type.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.