excel_conditional_formatting
Apply conditional formatting to Excel ranges using custom rules to highlight financial data patterns, identify trends, and visualize key metrics for analysis.
Instructions
Apply conditional formatting to a range
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| rules | Yes | ||
| worksheetName | Yes |
Input Schema (JSON Schema)
{
"properties": {
"range": {
"type": "string"
},
"rules": {
"items": {
"properties": {
"formulae": {
"items": {
"type": "string"
},
"type": "array"
},
"operator": {
"type": "string"
},
"style": {
"properties": {
"border": {
"type": "object"
},
"fill": {
"type": "object"
},
"font": {
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"type": "array"
},
"worksheetName": {
"type": "string"
}
},
"required": [
"worksheetName",
"range",
"rules"
],
"type": "object"
}