SetFormulaConditionalFormat(Int32,Int32,NamedStyle,String) Method

In This Topic

Sets conditional formatting based on a specified formula for a specified cell.

Syntax

Visual Basic
C#

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

'Usage
 
Dim instance As SheetView
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)

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

Parameters

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

Return Value

Boolean: true if successful; false otherwise

Reference

SheetView Class
SheetView Members
Overload List