Help Centre › Building Processes
This article describes the RPA Excel functionality to set background color.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Set background color function allows you to set background color.
Setting it up
To use the EXCEL Set background color function, follow these instructions:
{{popups:rpas/add:action=excel-color}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Set background color 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 Set background color option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Variable | Yes | Text | - | Variable to store the result |
| Color / Cell pairs | Yes | Table | - | Pairs of color value and cell reference |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Text | The result of the color operation |
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
Tips
- Use this to set background colors on cells