Update conditional format rule
The Google Sheets Update Conditional Format Rule tool allows users to modify existing conditional formatting rules within their spreadsheets. It enables precise control over how cells are visually formatted based on customizable conditions, enhancing data readability and analysis.
Features
- Modify existing conditional formatting rules in Google Sheets.
- Supports multiple condition types including text, numbers, dates, and booleans.
- Customize formatting with RGB colors and text styles like bold, italic, and strikethrough.
- Control the position of rules with zero-based indexing for rule order management.
- Compatible with shared drives and supports selection of specific worksheets and ranges.
Benefits
- Enhance data visualization to quickly identify important information.
- Automate spreadsheet styling for consistent and dynamic reports.
- Save time by programmatically updating conditional formatting without manual changes.
- Improve data accuracy by highlighting key trends and outliers automatically.
- Integrate seamlessly within workflows using Pipedream for efficient spreadsheet management.
Description
Modify existing conditional formatting rule. See the documentation
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- conditionValues: Return JSON in this format: string[]
Parameters
15 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-conditional-format-rule, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-conditional-format-rule, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-update-conditional-format-rule, propName: worksheetId. |
| rangerequired | string | The range of cells to protect (e.g., |
| conditionTyperequired | enum | The type of data condition |
| conditionValuesrequired | string[] | Values for condition (e.g., color scales or custom formulas) |
| formattingTyperequired | enum | Choose between boolean condition or gradient color scale |
| rgbColor | object | The RGB color value (e.g., {"red": 1.0, "green": 0.5, "blue": 0.2}) |
| textFormat | object | The text format options |
| bold | boolean | Whether the text is bold |
| italic | boolean | Whether the text is italic |
| strikethrough | boolean | Whether the text is strikethrough |
| interpolationPointType | enum | The interpolation point type |
| indexrequired | integer | The zero-based index of the rule |
| newIndex | integer | The new zero-based index of the rule |