Add conditional format
add_conditional_formatAdd conditional formatting rules to Excel ranges to highlight cells based on values, color scales, data bars, or custom formulas.
Instructions
Add a conditional format rule to a range.
Rule types: 'color_scale' (colors: 2 or 3), 'data_bar' (colors: 1), 'cell_value' (operator and values, e.g. greaterThan ['100']), and 'formula' (a formula that is true for highlighted cells, written for the range's top-left cell, e.g. '=$C2>100').
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | Path to an .xlsx, .xlsm, .xltx or .xltm file. Relative paths are resolved in the server's workbook directory when one is configured; otherwise use an absolute path. | |
| rule | Yes | ||
| range | Yes | A cell or rectangular range in A1 notation, e.g. 'A1:D20'. | |
| sheet | Yes | Worksheet name, e.g. 'Sheet1'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |