format_range
Applies font, fill, borders, alignment, wrap, and number formatting to a specified A1 cell range, changing only the properties you provide.
Instructions
Format a range: font (name, size, bold, italic, underline, color), fill color, borders (all/outline with style, weight, color), alignment, wrap, and number format. Only the provided properties are changed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | Bold text. | |
| range | Yes | A1 range address, e.g. "A1:C10". | |
| italic | No | Italic text. | |
| borders | No | Which borders to apply. "none" clears borders. | |
| fontName | No | Font family, e.g. "Calibri". | |
| fontSize | No | Font size in points. | |
| wrapText | No | Wrap text within cells. | |
| fillColor | No | Cell fill color as #RRGGBB, e.g. "#FFFF00". | |
| fontColor | No | Font color as #RRGGBB, e.g. "#FF0000". | |
| sheetName | No | Worksheet name. Defaults to the active worksheet. | |
| underline | No | Underline style. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. | |
| borderColor | No | Border color as #RRGGBB. Default "#000000". | |
| borderStyle | No | Border line style. Default "Continuous". | |
| numberFormat | No | Number format string, e.g. "0.00%". | |
| verticalAlignment | No | ||
| horizontalAlignment | No |