Click or drag to resize

ConditionalFormatRule Methods

The ConditionalFormatRule type exposes the following members.

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