add_conditional_format
Adds conditional formatting to a Google Sheets range with customizable background and text colors, using condition types like number comparison or text matching.
Instructions
Add a native conditional-formatting rule using #RRGGBB colors.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheet_id": "<spreadsheet_id>",
"range": "<range>",
"condition_type": "<condition_type>"
},
"name": "add_conditional_format"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | ||
| range | Yes | ||
| rule_index | No | ||
| text_color | No | ||
| condition_type | Yes | ||
| spreadsheet_id | Yes | ||
| background_color | No | ||
| condition_values | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||