Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | Leave empty for the first sheet |
Range range | string | Optional | — | The cells the rule watches, such as B2:B500 |
Highlight ruleType | enum | Optional | cellIs | —cellIscontainsTextcontainsErrorscontainsBlankstop10aboveAveragecolorScaledataBar |
Where the value is operator | enum | Optional | greaterThan | —greaterThangreaterThanOrEquallessThanlessThanOrEqualequalnotEqualbetweennotBetweenShown when ruleType = cellIs |
Value value1 | expression | Optional | — | — Shown when ruleType = cellIs |
And value2 | expression | Optional | — | — Shown when ruleType = cellIs |
Text text | expression | Optional | — | — Shown when ruleType = containsText |
How Many rank | number | Optional | 10 | — Shown when ruleType = top10 |
Bottom Instead of Top bottom | boolean | Optional | false | — Shown when ruleType = top10 |
Treat as a Percentage percent | boolean | Optional | false | — Shown when ruleType = top10 |
Above Average aboveAverage | boolean | Optional | true | — Shown when ruleType = aboveAverage |
Fill Colour fillColor | string | Optional | — | Defaults to Excel's pale red Shown when ruleType = cellIs / containsText / containsErrors / containsBlanks / top10 / aboveAverage |
Font Colour fontColor | string | Optional | — | — Shown when ruleType = cellIs / containsText / containsErrors / containsBlanks / top10 / aboveAverage |
Low Colour minColor | string | Optional | — | — Shown when ruleType = colorScale |
High Colour maxColor | string | Optional | — | — Shown when ruleType = colorScale |
Bar Colour barColor | string | Optional | — | — Shown when ruleType = dataBar |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Autofit Rows and Columns
Widen columns to fit their contents. Widths are estimated from the longest value rather than measured, and rows are handed back to Excel to fit when the file opens
Format as Table
Turn a range into a real Excel table with banded rows, filter arrows and a name formulas can use
Format Cells
Set fill, font, borders, alignment, number format and size on a range. Every field is optional and only the ones filled in are changed
Merge Cells
Join a range into one cell, or split a merged one back up. Safe to re-run
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row