sheets_add_conditional_formatting
Apply conditional formatting rules to a Google Sheet to automatically highlight cells based on specified criteria, enhancing data readability and analysis.
Instructions
Add conditional formatting rules to a Google Sheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rules | Yes | ||
| spreadsheetId | Yes |
Input Schema (JSON Schema)
{
"properties": {
"rules": {
"_def": {
"exactLength": null,
"maxLength": null,
"minLength": null,
"type": {
"_cached": null,
"_def": {
"catchall": {
"_def": {
"typeName": "ZodNever"
},
"~standard": {
"vendor": "zod",
"version": 1
}
},
"typeName": "ZodObject",
"unknownKeys": "strip"
},
"~standard": {
"vendor": "zod",
"version": 1
}
},
"typeName": "ZodArray"
},
"~standard": {
"vendor": "zod",
"version": 1
}
},
"spreadsheetId": {
"_def": {
"checks": [],
"coerce": false,
"typeName": "ZodString"
},
"~standard": {
"vendor": "zod",
"version": 1
}
}
},
"required": [
"spreadsheetId",
"rules"
],
"type": "object"
}