sheets_conditional_format
Apply conditional formatting rules to Google Sheets cells based on numeric comparisons, text content, or custom formulas to highlight data patterns automatically.
Instructions
Add conditional formatting. rule_type: NUMBER_GREATER, NUMBER_LESS, NUMBER_EQ, TEXT_CONTAINS, TEXT_NOT_CONTAINS, CUSTOM_FORMULA. For CUSTOM_FORMULA, condition_value is the formula (e.g., '=A1>8').
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet | Yes | ||
| sheet_name | Yes | ||
| range_a1 | Yes | ||
| rule_type | Yes | ||
| condition_value | Yes | ||
| bg_color | No | #ea9999 |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |