Applies Value based Conditional Formatting to an Excel range
Last updated 2 years ago
Name | Excel Conditional Value
Nickname | XL Value
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.
T | Type (Integer) | The conditional formatting type.
C | Color (Colour) | The conditional formatting color.
O | Settings (Text) | Excel Workbook options.
_S | Stream (Boolean) | True to Read data from Excel.
R | Range Address (Text) | The range address
