AddCellValueRule Method

Visual Basic
C#

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

'Usage
 
Dim instance As ConditionalFormat
Dim comparisonOperator As ComparisonOperator
Dim value1 As System.Object
Dim value2 As System.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,
   System.object value1,
   System.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#

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.Windows.SpreadSheet.Data.StyleInfo();
style2.Background = new SolidColorBrush(Colors.Yellow);

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

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
Dim style2 As New GrapeCity.Windows.SpreadSheet.Data.StyleInfo()
style2.Background = New SolidColorBrush(Colors.Yellow)

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

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

ConditionalFormat Class
ConditionalFormat Members