This activity helps the user to set “color” either to the “Text/Value” or to the specified
“Cell” in the provided input excel sheet. This activity works within the Excel scope
activity.

Technical Reference

	INPUT	Cell: Indicates to provide the “Cell” reference to set the color in it. This parameter 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: Indicates to choose the “Style” options whether it needs to be applied to the “text” or in the “Cell”. Choose the option from drop-down,   Font: Applies the color only to the “text” in the cell. Background: Applies the color to the whole cell.   By default, it will be configured to “Font”.
		SheetName: Indicates to provide the  “SheetName” to set the color against the cell in the provided input excel worksheet. This parameter 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: It provides the ability to view the execution status of the activity. It returns values 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

Here’s an example of how “SetCellFormula” activity works –

In the following example, I am using the “Excel sheet” which is used to automate in
the Use case. To get a better understanding, click here.

This report encompasses employee particulars like Name, Position, Age, Office,
Start date, and Salary.

1.       Here, I am continuing from the “WriteCellFormula” activity’s example.

2.       Now, placing the " SetCellFormula " activity within the scope activity.

a.       Here I am going to set the color for the total amount written in the “H1”
cell using this activity. 

b.       Double click on the activity and providing the cell value as “H1” where the
calculated amount is located in the sheet.

c.       Next, moving to “SheetName” and providing the value as “Report”.

d.       Now, navigating to the “CellColor” properties to set the color.

i.      Here I am choosing the color as “Blue”. You can choose the colors from
the drop-down.

e.       Next, moving to the “FormatStyle” properties to set the styling options for
the cell.

i.      By default, it will be set to “Font”, so I am not making any changes and
proceeding with the same.

3.       Now, execute the workflow.

The bot will run the workflow and set the color “Blue” only to the value in
the cell “H1”. Below is the sample of the output.