Click or drag to resize

ConditionalFormatRule Class

Represents a conditional formatting rule.
Inheritance Hierarchy
SystemObject
  GemBox.Spreadsheet.ConditionalFormattingConditionalFormatRule

Namespace:  GemBox.Spreadsheet.ConditionalFormatting
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 43.0.35.1036
Syntax
public sealed class ConditionalFormatRule

The ConditionalFormatRule type exposes the following members.

Properties
  NameDescription
Public propertyAppliesTo
Gets or sets the sequence of references to cell ranges over which this conditional formatting rule is applied.
Public propertyCondition
Gets the condition specified in this conditional formatting rule.
Public propertyStopIfTrue
Gets or sets a value indicating whether a rule with lower priority may be applied over this rule, when this rule evaluates to true.
Top
Methods
  NameDescription
Public methodSet2ColorScale
Sets a '2-Color Scale' formatting condition to this conditional formatting rule.
Public methodSet3ColorScale
Sets a '3-Color Scale' formatting condition to this conditional formatting rule.
Public methodSetAboveOrBelowAverage
Sets an 'Above or Below Average' formatting condition to this conditional formatting rule.
Public methodSetContain
Sets a 'Cells with Blanks' or 'Cells with No Blanks' or 'Cells with Errors' or 'Cells with No Errors' formatting condition to this conditional formatting rule.
Public methodSetContainDate
Sets a 'Cells with Dates Occurring' formatting condition to this conditional formatting rule.
Public methodSetContainText
Sets a 'Cells with Specific Text' formatting condition to this conditional formatting rule.
Public methodSetContainValue(ContainValueOperator, Object)
Sets a 'Cells with Cell Value' formatting condition to this conditional formatting rule.
Public methodSetContainValue(ContainValueOperator, Object, Object)
Sets a 'Cells with Cell Value' formatting condition to this conditional formatting rule.
Public methodSetDataBar
Sets a 'Data Bar' formatting condition to this conditional formatting rule.
Public methodSetFormula
Sets a 'Formula' formatting condition to this conditional formatting rule.
Public methodSetIconSet
Sets an 'Icon Set' formatting condition to this conditional formatting rule.
Public methodSetTopOrBottomRanked
Sets a 'Top or Bottom Ranked' formatting condition to this conditional formatting rule.
Public methodSetUniqueOrDuplicate
Sets a 'Unique or Duplicate' formatting condition to this conditional formatting rule.
Public methodToString
Returns a String that represents this ConditionalFormatRule instance.
(Overrides ObjectToString.)
Top
See Also