Icon

Colour Spreadsheet

Demo of formatting entire rows based on colour coding

file 1file 2join "files" by Keyto compareGenerate control tableDefine rulesfor row colourPopulate all cells withrow colourremove additionalcolumnwrite data tabletoexcel filecomponent to create a new pathvariable with samefilename but -f suffixread original fileand apply formattingto new file with -f suffix. Red BackBlue BackGreen BackYellow BackWhite fore for RedWhite fore for BlueTable Creator Table Creator Joiner XLS ControlTable Generator Rule Engine String Manipulation(Multi Column) Column Filter Excel Writer Edit PathVariable Filename XLS Formatter(apply) XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS Font Formatter XLS Font Formatter file 1file 2join "files" by Keyto compareGenerate control tableDefine rulesfor row colourPopulate all cells withrow colourremove additionalcolumnwrite data tabletoexcel filecomponent to create a new pathvariable with samefilename but -f suffixread original fileand apply formattingto new file with -f suffix. Red BackBlue BackGreen BackYellow BackWhite fore for RedWhite fore for BlueTable Creator Table Creator Joiner XLS ControlTable Generator Rule Engine String Manipulation(Multi Column) Column Filter Excel Writer Edit PathVariable Filename XLS Formatter(apply) XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS BackgroundColorizer XLS Font Formatter XLS Font Formatter

Nodes

Extensions

Links