FormatCondition Properties

The FormatCondition type exposes the following members.

Properties
  NameDescription
Public propertyAboveAverage
Get the conditional formatting's "AboveAverage" instance. The default instance's rule highlights cells that are above the average for all values in the range. Valid only for type = AboveAverage.
Public propertyColorScale
Get the conditional formatting's "ColorScale" instance. The default instance is a "green-yellow-red" 3ColorScale . Valid only for type = ColorScale.
Public propertyDataBar
Get the conditional formatting's "DataBar" instance. The default instance's color is blue. Valid only for type is DataBar.
Public propertyFormula1
Gets and sets the value or expression associated with conditional formatting.
Public propertyFormula2
Gets and sets the value or expression associated with conditional formatting.
Public propertyIconSet
Get the conditional formatting's "IconSet" instance. The default instance's IconSetType is TrafficLights31. Valid only for type = IconSet.
Public propertyOperator
Gets and sets the conditional format operator type.
Public propertyPriority
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.
Public propertyStopIfTrue
True, no rules with lower priority may be applied over this rule, when this rule evaluates to true. Only applies for Excel 2007;
Public propertyStyle
Gets or setts style of conditional formatted cell ranges.
Public propertyText
The text value in a "text contains" conditional formatting rule. Valid only for type = containsText, notContainsText, beginsWith and endsWith. The default value is null.
Public propertyTimePeriod
The applicable time period in a "date occurring¡­" conditional formatting rule. Valid only for type = timePeriod. The default value is TimePeriodType.Today.
Public propertyTop10
Get the conditional formatting's "Top10" instance. The default instance's rule highlights cells whose values fall in the top 10 bracket. Valid only for type is Top10.
Public propertyType
Gets and sets whether the conditional format Type.
See Also