Skip to content

Set Cell Format

Apply number format / bold / fill to a cell.

ExcelExcelSetFormatCell

Overview

Set Cell Format is a no-code automation step in the Excel category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 9 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.

What it does

Apply number format / bold / fill to a cell.

Parameters

ParameterTypeRequiredDefaultDescription
Excel instancevariable
RequiredexcelName that identifies this open workbook.
Sheet (blank = active)string
OptionalWorksheet name; blank uses the active sheet.
Supports variables
Reference bydropdown
A1 (Cell) · Row & Column
OptionalA1 (Cell)
Cell (A1) — for A1 modestring
Optional
Example: A1
Supports variables
Row (1-based) — for Row & Column modenumber
Optional
Example: 1
Supports variables
Column (1-based) — for Row & Column modenumber
Optional
Example: 1
Supports variables
Number formatstring
Optionale.g. 0.00 or #,##0 or yyyy-mm-dd.
Example: 0.00
Supports variables
Bolddropdown
No · Yes
OptionalNo
Background color (hex)string
Optional6-digit hex, e.g. FFFF00.
Example: FFFF00
Supports variables

How to use Set Cell Format

  1. 1

    Open AutoFlowRPA and drag the Set Cell Format command from the Excel group onto the canvas.

  2. 2

    Set its parameters in the side panel — Set Cell Format has 9 configurable field(s).

  3. 3

    Connect it into your workflow and press Run. Everything executes locally on your machine.

Frequently asked questions

What does the Set Cell Format command do?

Apply number format / bold / fill to a cell.

Which group does the Set Cell Format command belong to?

Set Cell Format is part of the Excel group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.

Does the Set Cell Format command take any parameters?

Yes — Set Cell Format has 9 configurable field(s), all editable in the visual node editor.

More Excel commands

Ready to automate your busywork?

Start your free 30-day trial today. No credit card, no commitment.