format_cells
Apply cell formatting to a specified A1 range in Google Sheets, including font, color, alignment, wrapping, and number formats. Only the arguments passed are changed.
Instructions
Apply cell formatting to an A1 range. Only the arguments you pass change.
text_color/background_color:"#RRGGBB", a named color (red, blue, lightgray, ...), or omit to leave unchanged.horizontal_alignment:LEFT|CENTER|RIGHT.vertical_alignment:TOP|MIDDLE|BOTTOM.wrap_strategy:OVERFLOW_CELL|CLIP|WRAP.number_format_type:TEXT|NUMBER|PERCENT|CURRENCY|DATE|TIME|DATE_TIME|SCIENTIFIC; pair with an optionalnumber_format_pattern(e.g."$#,##0.00","0.0%").
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| range | Yes | ||
| italic | No | ||
| font_size | No | ||
| underline | No | ||
| text_color | No | ||
| font_family | No | ||
| strikethrough | No | ||
| wrap_strategy | No | ||
| spreadsheet_id | Yes | ||
| background_color | No | ||
| number_format_type | No | ||
| vertical_alignment | No | ||
| horizontal_alignment | No | ||
| number_format_pattern | No |