AddFormulaRule Method

In This Topic

Adds the formula rule to the rule collection.

Syntax

Visual Basic
C#

'Declaration
 
Public Function AddFormulaRule( _
   ByVal formula As String, _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As FormulaRule

'Usage
 
Dim instance As ConditionalFormat
Dim formula As String
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As FormulaRule
 
value = instance.AddFormulaRule(formula, style, ranges)

public FormulaRule AddFormulaRule( 
   string formula,
   StyleInfo style,
   params CellRange[] ranges
)

Parameters

formula: The condition formula.
style: The style that is applied to the cell when the condition is met.
ranges: The cell ranges where the rule is applied.

Return Value

Returns the new formula rule.

Reference

ConditionalFormat Class
ConditionalFormat Members