Conditional formatting
xlide_manage_conditional_formatList, add, or clear conditional formatting rules in Excel files to color cells by value comparisons, formulas, color scales, or data bars.
Instructions
Lists, adds or clears conditional formatting: the rules that colour cells by what is in them. rule='cell_is' with an operator and a value paints cells that compare true; rule='expression' takes a formula written for the top-left cell of the range and applied relatively, the way Excel's 'Use a formula' box works; rule='color_scale' and 'data_bar' are the gradient and in-cell bar. The paint itself is the fill and font arguments, which is what Excel calls a differential format.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bold | No | Make matching cells bold. | |
| rule | No | cell_is, expression, color_scale or data_bar. | cell_is |
| sheet | Yes | Worksheet name, matched without case. | |
| value | No | For cell_is: the value compared against. | |
| action | No | list, add or clear. | list |
| formula | No | For expression: a formula for the range's top-left cell. | |
| operator | No | For cell_is: greaterThan, between, etc. | greaterThan |
| file_path | Yes | Absolute path to the Excel file. | |
| cell_range | No | For add and clear: the range. Empty clears the whole sheet. | |
| fill_color | No | Fill to paint matching cells, as hex. | |
| font_color | No | Text colour for matching cells, as hex. | |
| other_value | No | For cell_is with between: the second value. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||