SetFormulaConditionalFormat Method (IConditionalFormatSupport2)

In This Topic

Sets a formula conditional format for the cell at the specified row and column.

Syntax

Visual Basic
C#

'Declaration
 
Function SetFormulaConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal style As NamedStyle, _
   ByVal formula As String _
) As Boolean

'Usage
 
Dim instance As IConditionalFormatSupport2
Dim row As Integer
Dim column As Integer
Dim style As NamedStyle
Dim formula As String
Dim value As Boolean
 
value = instance.SetFormulaConditionalFormat(row, column, style, formula)

bool SetFormulaConditionalFormat( 
   int row,
   int column,
   NamedStyle style,
   string formula
)

Parameters

row: Row index of cell
column: Column index of cell
style: Style to be applied to the cell if the formula evaluates to true
formula: Formula for the condition

Reference

IConditionalFormatSupport2 Interface
IConditionalFormatSupport2 Members