XLS Conditional Formatter

The XLS Conditional Formatter node defines instruction for your spreadsheet application to color cell backgrounds according to their numeric value.

This node defines a formatting instruction only which needs to be written to an xlsx file via the XLS Formatter (apply) node subsequently.

Options

Tag Selection

applies to tag (single tag only)

Tag in your input table for which the formatting of this node should be applied to.

Conditional Formatting Settings

Mid scale point needed?

Set this option if you want to create a three level coloring scheme.

min

Set the lower bound for the coloring in the conditional formatter. The corresponding color will be displayed for all values smaller or equal than this threshold.

min color

Select the color using the color pane.

mid

Set the middle scaling point for the coloring in the conditional formatter.

mid color

Select the color using the color pane.

max

Set the upper bound for the coloring in the conditional formatter. The corresponding color will be displayed for all values greater or equal than this threshold.

max color

Select the color using the color pane.

Views

This node has no views

Workflows

• 01_Correlation_MatrixKNIME Hub
• 07_XLS_ConditionalFormatterKNIME Hub
• 2nd Vernalis Benchmark example for Excel nodesKNIME Forum
• Continental Nodes ExampleKNIME Hub
• Demo XLS Control Table Auto Tag GeneratorKNIME Hub
• Show all 17 workflows

Links

• Formating Issueby izaychik63 on 2020-05-04

  forum.knime.com/p/89926

Developers