Applies Scalar Conditional Formatting to an Excel range
Last updated 2 years ago
Name | Excel Conditional Scale
Nickname | XL Scale
Tab | TTToolbox
Panel | Excel
Division | 3
Wb | Workbook Filepath (Text) | Path to the excel file to open. If none is provided, the open workbook will be read or a new one will be created.
Ws | Worksheet Name (Text) | Worksheet name or index (starting from 1). If none is provided, the frontmost worksheet will be used.
R | Range (Text) | An optional Range to select
C | Colors (Colour) | The conditional formatting colors.
O | Settings (Text) | Excel Workbook options
_S | Stream (Boolean) | True to Read data from excel
R | Range Address (Text) | The range address
