This article describes the RPA Excel functionality to apply conditional formatting to a range.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL Conditional format function applies conditional formatting to a range. Highlights cells based on a cell value condition with a background colour. Clears any existing conditional formats on the range before applying.

Setting it up

To use the EXCEL Conditional format function, follow these instructions:

Once on a process map:

Navigate to the process where you would like to add the EXCEL Conditional format function
Click on the green button's drop-down (right side of the green button labelled "Process")
On the menu that appears, click on the "+ Activity" item
From here you can select the EXCEL Conditional format option
Click "Add" once you are done

Input parameters

Parameter	Required	Type	Default	Description
File path	Yes	Text	–	Full path to the Excel file.
Sheet	Yes	Text	–	Name of the sheet.
Range	Yes	Text	–	Range to format (e.g. A1:A100).
Operator	Yes	Select	–	Operator: >, <, >=, <=, =, !=, between.
Value	Yes	Text	–	Threshold value. For 'between', use two values separated by a comma (e.g. 10,20).
Background colour	No	Text	FF0000	Hex background colour (e.g. FF0000 for red).

Output variables

This action does not produce any output variables.

Errors

Error	Description
File not open	The Excel file must be open.
Sheet not found	The specified sheet does not exist.
Invalid range	The range is not valid.
Invalid operator	The operator is not supported.

Tips

Existing conditional formats on the range are cleared before the new rule is applied.
For the 'between' operator, separate the two values with a comma (e.g. 10,20).
Colour is specified as a hex value without the # prefix (e.g. FF0000 for red, 00FF00 for green).

EXCEL Conditional format function