Format cells
format_rangeApply formatting to a Google Sheets range, including fonts, colors, number formats, alignment, wrapping, and borders. Only specified options are changed.
Instructions
Apply formatting to a range: font styles, colors, number formats, alignment, wrapping, borders. Only provided options are changed. To style several ranges differently in one go, use format_ranges.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| wrap | No | ||
| range | Yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name | |
| italic | No | ||
| account | No | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. | |
| borders | No | ||
| font_size | No | ||
| underline | No | ||
| text_color | No | Hex, e.g. #1a73e8 | |
| font_family | No | ||
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works | |
| number_format | No | ||
| strikethrough | No | ||
| background_color | No | Hex, e.g. #f1f3f4 | |
| clear_formatting | No | Reset all formatting first | |
| vertical_alignment | No | ||
| horizontal_alignment | No |