Definition and Usage
Apply formatting (e.g. number format, font, alignment, fill) to the specified cell or range. This command allows you to modify the appearance and format properties of cells in an Excel worksheet.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on |
| Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Worksheet name | Specify the worksheet name |
| No | Leave blank for the active worksheet |
Reference range | The target cell or range to format | Cell, Row, Column, Range, Used range | Yes |
|
Row | Enter the row number, starting from 1. Use -n to indicate the nth row from the bottom |
| Conditional | Required when Reference range is "Cell", "Row" |
Column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Conditional | Required when Reference range is "Cell", "Column" |
Starting row | Specify the starting row number. Use 1 for the first row, or -1 for the last row |
| Conditional | Required when Reference range is "Range" |
Ending row | Specify the ending row number. Use 1 for the first row, or -1 for the last row |
| Conditional | Required when Reference range is "Range" |
Starting column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Conditional | Required when Reference range is "Range" |
Ending column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
| Conditional | Required when Reference range is "Range" |
Cell format | Format settings for the cell(s) |
| Yes | Click "Format Cell" button to configure format options |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables for parameters such as row numbers, column references, or worksheet names. When you see the {x} icon next to a field, you can insert variables created in previous steps. This is particularly useful when you need to dynamically reference cells based on calculated values or data obtained during workflow execution.
Notes
Before using this command, ensure that a valid Excel instance has been created and the target file is open.
The "Format Cell" button opens a dialog where you can configure number formats, fonts, borders, alignment, and other cell formatting options.
When specifying row and column values, you can use positive numbers (counting from the beginning) or negative numbers (counting from the end).
For column references, you can use either numbers (1, 2, 3) or Excel-style letters (A, B, C).
The "Used range" option applies formatting to all cells that contain data in the worksheet.