excel_apply_conditional_format
Apply conditional formatting rules to an Excel range using conditions, color scales, data bars, or top/bottom rules to highlight key data.
Instructions
Apply conditional formatting to a range
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the Excel file | |
| sheetName | Yes | Name of the sheet | |
| range | Yes | Range to format (e.g., A1:D10) | |
| ruleType | Yes | ||
| condition | No | Condition for cellValue type | |
| style | No | Style to apply | |
| colorScale | No | Color scale settings | |
| createBackup | No |