← MCP Catalog

format_range

Apply explicit visual and number formatting to an A1 range without changing values. Colors accept #RGB or #RRGGBB. Alignments are LEFT/CENTER/RIGHT and TOP/MIDDLE/BOTTOM. Wrap strategy is OVERFLOW_CELL, LEGACY_WRAP, CLIP, or WRAP. Common number types are NUMBER, PERCENT, CURRENCY, DATE, TIME, DATE_TIME, and TEXT.

MCPGoogle Sheets AuthorizationPrivate connector

Can change or delete data

Parameters

spreadsheet_idstring · required

sheetstring · required

rangestring · required

background_colorstring · default null

text_colorstring · default null

boldboolean · default null

italicboolean · default null

font_sizeinteger · default null

horizontal_alignmentstring · default null

vertical_alignmentstring · default null

wrap_strategystring · default null

number_format_typestring · default null

number_format_patternstring · default null