← MCP Catalog

add_conditional_format

Add a boolean conditional-format rule at the requested priority. Examples include NUMBER_GREATER with values=['100'], TEXT_CONTAINS with values=['urgent'], CUSTOM_FORMULA with values=['=$D2="Late"'], or BLANK.

MCPGoogle Sheets AuthorizationPrivate connector
Can change or delete data

Parameters

spreadsheet_idstring · required

sheetstring · required

rangestring · required

condition_typestring · required

valuesarray · default null

background_colorstring · default null

text_colorstring · default null

boldboolean · default false

italicboolean · default false

rule_indexinteger · default 0