Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / ConditionalFormat Class / AddFormulaRule Method
The condition formula.
The style that is applied to the cell when the condition is met.
The cell ranges where the rule is applied.

In This Topic
    AddFormulaRule Method
    In This Topic
    Adds the formula rule to the rule collection.
    Public Function AddFormulaRule( _
       ByVal formula As String, _
       ByVal style As StyleInfo, _
       ByVal ParamArray ranges() As CellRange _
    ) As FormulaRule
    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


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

    Return Value

    Returns the new formula rule.
    This example creates a formula rule.
    GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
    GcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 1;
    GcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 1;
    GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 1;
    var style2 = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
    style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);
    GcSpreadSheet1.Sheets[0].ConditionalFormats.AddFormulaRule("=A1=B1+C1", style2, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] { new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) });
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
    GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 1
    GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 1
    GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 1
    Dim style2 As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
    style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)
    GcSpreadSheet1.Sheets(0).ConditionalFormats.AddFormulaRule("=A1=B1+C1", style2, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() { New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1) })
    See Also