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
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": {
"filePath": "<filePath>",
"sheetName": "<sheetName>",
"range": "<range>",
"ruleType": "<ruleType>"
},
"name": "excel_apply_conditional_format"
}
}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 |