Set Cell Format
Apply number format / bold / fill to a cell.
ExcelExcelSetFormatCell
What it does
Apply number format / bold / fill to a cell.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Excel instance | variable | Required | excel | Name that identifies this open workbook. |
| Sheet (blank = active) | string | Optional | Worksheet name; blank uses the active sheet. Supports variables | |
| Reference by | dropdownA1 (Cell) · Row & Column | Optional | A1 (Cell) | |
| Cell (A1) — for A1 mode | string | Optional | Example: A1 Supports variables | |
| Row (1-based) — for Row & Column mode | number | Optional | Example: 1 Supports variables | |
| Column (1-based) — for Row & Column mode | number | Optional | Example: 1 Supports variables | |
| Number format | string | Optional | e.g. 0.00 or #,##0 or yyyy-mm-dd. Example: 0.00 Supports variables | |
| Bold | dropdownNo · Yes | Optional | No | |
| Background color (hex) | string | Optional | 6-digit hex, e.g. FFFF00. Example: FFFF00 Supports variables |
More Excel commands
Ready to automate your busywork?
Start your free 10-day trial today. No credit card, no commitment.