Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / IConditionalFormatSupport2 Interface / SetFormulaConditionalFormat Method
Row index of cell
Column index of cell
Style to be applied to the cell if the formula evaluates to true
Formula for the condition


In This Topic
    SetFormulaConditionalFormat Method (IConditionalFormatSupport2)
    In This Topic
    Sets a formula conditional format for the cell at the specified row and column.
    Syntax
    '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
    See Also