AddCellValueRule Method

Visual Basic
C#

'Declaration
 
Public Function AddCellValueRule( _
   ByVal comparisonOperator As ComparisonOperator, _
   ByVal value1 As Object, _
   ByVal value2 As Object, _
   ByVal style As StyleInfo, _
   ByVal ParamArray ranges() As CellRange _
) As CellValueRule

'Usage
 
Dim instance As ConditionalFormat
Dim comparisonOperator As ComparisonOperator
Dim value1 As Object
Dim value2 As Object
Dim style As StyleInfo
Dim ranges() As CellRange
Dim value As CellValueRule
 
value = instance.AddCellValueRule(comparisonOperator, value1, value2, style, ranges)

public CellValueRule AddCellValueRule( 
   ComparisonOperator comparisonOperator,
   object value1,
   object value2,
   StyleInfo style,
   params CellRange[] ranges
)

Parameters

comparisonOperator: The ComparisonOperator comparison operator.
value1: The first value.
value2: The second value.
style: The style that is set to the cell when the condition is met.
ranges: The cell ranges where the rule is applied.

Return Value

Returns the new cell value rule.

This example creates a cell value rule.

C#
VB.NET

GcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 1;
GcSpreadSheet1.Sheets[0].Cells[1, 0].Value = 10;
GcSpreadSheet1.Sheets[0].Cells[2, 0].Value = 6;
GcSpreadSheet1.Sheets[0].Cells[3, 0].Value = -3;
var style2 = new GrapeCity.Xaml.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Windows.UI.Colors.Yellow);

GcSpreadSheet1.Sheets[0].ConditionalFormats.AddCellValueRule(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, new GrapeCity.Xaml.SpreadSheet.Data.CellRange[] {new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)});

GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 1
GcSpreadSheet1.Sheets(0).Cells(1, 0).Value = 10
GcSpreadSheet1.Sheets(0).Cells(2, 0).Value = 6
GcSpreadSheet1.Sheets(0).Cells(3, 0).Value = -3
Dim style2 As New GrapeCity.Xaml.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Windows.UI.Colors.Yellow)

GcSpreadSheet1.Sheets(0).ConditionalFormats.AddCellValueRule(GrapeCity.Xaml.SpreadSheet.Data.ComparisonOperator.Between, 1, 8, style2, New GrapeCity.Xaml.SpreadSheet.Data.CellRange() {New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)})

Reference

ConditionalFormat Class
ConditionalFormat Members