Add conditional formatting
add_conditional_formatApply conditional formatting rules to Google Sheets ranges using numeric, text, date, blank, or custom formula conditions, or color scales.
Instructions
Add a conditional formatting rule: either a condition (e.g. NUMBER_GREATER, TEXT_CONTAINS, CUSTOM_FORMULA) with a style, or a color scale.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name | |
| 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. | |
| condition | No | ||
| color_scale | No | ||
| spreadsheet | Yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |