Click or drag to resize

ExcelConditionalFormat Class

Represents a conditional format rule of a range of cells. The rules are created with the methods of the ExcelConditionalFormatsCollection returned by ConditionalFormats. The font, fill and border properties apply to the cell value and formula rules; the data bar and icon set properties apply only to the rules of these types.
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelConditionalFormat

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public class ExcelConditionalFormat

The ExcelConditionalFormat type exposes the following members.

Properties
 NameDescription
Public propertyBackColor 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.
Public propertyBarColor Gets or sets the color of the bars of a data bar rule.
Public propertyBold Gets or sets a value indicating if the font of the cells that meet the condition is bold.
Public propertyFontColor 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.
Public propertyIconSet Gets or sets the icons of an icon set rule.
Public propertyItalic Gets or sets a value indicating if the font of the cells that meet the condition is italic.
Public propertyOperator Gets or sets the comparison operator of a cell value rule.
Public propertyReverseIconOrder Gets or sets a value indicating if the icons of an icon set rule are displayed in reverse order. The default value is false.
Public propertyShowIconOnly 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.
Public propertyShowValue 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.
Public propertyStrikethrough Gets or sets a value indicating if the text of the cells that meet the condition is struck through.
Public propertyType Gets the type of this conditional format rule.
Public propertyUnderline Gets or sets a value indicating if the text of the cells that meet the condition is underlined with a single line.
Public propertyValue1 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.
Public propertyValue2 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.
Top
See Also