SetCellColor

This activity helps the user to set “color” either to the “Text” or to the specified “Cell” in the specified sheet. It functions within the Excel scope activity.

Properties

INPUT

Cell:  *Specify the “Cell” reference value to set the color, and it accepts values in the “String” datatype.

CellColor: *This parameter helps you to choose a wide range of colors to be applied in the font. You can choose the colors from the drop-down.

FormatStyle: Choose whether the “Style” should be applied to the text or the cell. Select the desired option from the drop-down menu.
Font: Allows applying color to the text within a cell.
Background: Enables applying color to the entire cell, including its background.

By default, it will be configured to “Font”.

SheetName: *Specify the “SheetName” to set the color against the cell, and it accepts values in the “String” datatype.”

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.