Hello,
I am a beginner to Knime and am looking to use it for a workflow I have in excel.
My workflow uses sumifs to calculate one month’s value of a cost element as a % of four month’s value of the same cost element.
From this the conditional formatting analyses whether or not the 1 month is roughly a quarter of the total 4 month’s value.
If anyone has any ideas on nodes that they think may be helpful with this I would appreciate any steer on this topic.
Thank you in advance,
Sam
Hi @sammeredith , welcome to the forum.
Here’s a workflow that should get you started.
Conditional formatting isn’t really a thing in KNIME unless you’re going to be exporting to Excel. In that case, you’d use the XLS Coloured Writer node and specify your conditions.
3 Likes
Hello @elsamuel ,
Thank you very much for your support on this it is fantastic!
I will update you on how I get on with it.
Thanks again,
Sam
The Continental Nodes for KNIME provide many nodes with respect to Excel formatting:
Best,
Julian
Brilliant, thank you I will look into this too.
system
Closed
August 27, 2021, 11:53pm
6
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.