List Conditional Formatting Rules
list_conditional_format_rulesInspect conditional formatting rules on a specified Excel range, returning rule types, operator codes, and formulas for auditing or troubleshooting formatting logic.
Instructions
List conditional formatting rules applied to a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "A1:A20".
Returns: JSON with each rule's index, COM Type/Operator codes, and formulas (cell-value rules only report formulas; color scales report just the type).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| workbook | No | ||
| range_address | No | A1 |