ConditionalFormat Properties

Get the conditional formatting's "Average" instance. The default instance's rule highlights cells that are above the average for all values in the range. Valid only for type = Average.

Pattern background color.

Conditional format background color. Read-only.

Pattern background excel color.

Color of the bottom line.

Conditional format bottom border color. Read-only.

Excel color of the bottom line.

Bottom border line style.

Pattern foreground color.

Get the conditional formatting's "ColorScale" instance. The default instance is a "green-red" 2ColorScale . Valid only for type = ColorScale.

Gets the DataBar object associated with the current instance.

Gets or sets the DXF ID, which is a unique identifier for an entity in a DXF (Drawing Interchange Format) file.

XlsFill pattern type.

First formula.

First formula in R1C1 notation. Read only.

Font color.

Conditional format font color. Read-only.

Font excel color.

conditional format type.

Returns iconset settings. Valid only if FormatType is set to IconSet. Read-only.

Indicates whether background color present.

Indicates whether font is bold.

Indicates whether contains border formatting.

Indicates whether bottom border style and color are modified.

Indicates whether format color present.

Indicates whether contains font formatting.

Indicates whether font is italic.

Indicates whether left border style and color are modified.

Determines whether the specified input contains a number format.

Indicates whether presents pattern color.

Indicates whether contains pattern formatting.

Indicates whether pattern style was modified.

Indicates right border style and color modified.

Indicates whether font is striked through.

Indicates whether font is subscript.

Indicates whether font is superscript.

Indicates whether top border style and color are modified.

Pattern foreground excel color.

Color of the left line.

Conditional format left border color. Read-only.

Excel color of the left line.

Left border line style.

Gets or sets the number format of the cell.

Conditional format color. Read-only.

Type of the comparison operator.

Reference to Parent object. Read-only.

The priority of this conditional formatting rule. This value is used to determine which format should be evaluated and rendered. Lower numeric values are higher priority than higher numeric values, where '1' is the highest priority.

Get quantity of instance references.

Color of the right line.

Conditional format right border color. Read-only.

Color of the right line.

Right border line style.

Second formula.

Second formula in R1C1 notation. Read only.

True, no rules with lower priority may be applied over this rule, when this rule evaluates to true. Only applies for Excel 2007;

Color of the top line.

Conditional format top border color. Read-only.

Excel color of the top line.

Top border line style.

Get the conditional formatting's "TopBottom" instance. The default instance's rule highlights cells whose values fall in the top 10 bracket. Valid only for type = TopBottom.

Underline type.