Excel |
The ExcelConditionalFormat type exposes the following members.
| Name | Description | |
|---|---|---|
| BackColor | Gets or sets the background color applied to the cells that meet the condition of a cell value or formula rule. In the Excel 97-2003 format the color is replaced by the nearest color of the workbook palette. | |
| BarColor | Gets or sets the color of the bars of a data bar rule. | |
| Bold | Gets or sets a value indicating if the font of the cells that meet the condition is bold. | |
| FontColor | Gets or sets the font color applied to the cells that meet the condition of a cell value or formula rule. In the Excel 97-2003 format the color is replaced by the nearest color of the workbook palette. | |
| IconSet | Gets or sets the icons of an icon set rule. | |
| Italic | Gets or sets a value indicating if the font of the cells that meet the condition is italic. | |
| Operator | Gets or sets the comparison operator of a cell value rule. | |
| ReverseIconOrder | Gets or sets a value indicating if the icons of an icon set rule are displayed in reverse order. The default value is false. | |
| ShowIconOnly | Gets or sets a value indicating if the cells of an icon set rule display only the icon, without the cell value. The default value is false. | |
| ShowValue | Gets or sets a value indicating if the cells of a data bar rule display their values next to the bars. The default value is true. | |
| Strikethrough | Gets or sets a value indicating if the text of the cells that meet the condition is struck through. | |
| Type | Gets the type of this conditional format rule. | |
| Underline | Gets or sets a value indicating if the text of the cells that meet the condition is underlined with a single line. | |
| Value1 | Gets or sets the first value of a cell value rule or the formula of a formula rule. The value is an Excel formula without the leading equal sign: a number like "100", a cell reference like "$H$2" or a text in double quotes like "\"North\"". The relative references of a formula rule are relative to the top left cell of the formatted range. | |
| Value2 | Gets or sets the second value of a cell value rule with the Between or NotBetween operator. The value has the same syntax as Value1. |