Spread ASP.NET 6.0 Product Documentation
SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String) Method
See Also Example Send Feedback

FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class > SetConditionalFormat Method : SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

row: Row index of the cell

column: Column index of the cell

style: Style to be applied to the cell if the condition is satisfied

op: Comparison operator to apply to the cell value and the specified value

value: String with the specified value

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

Syntax

Visual Basic (Declaration)
Public Overloads Function SetConditionalFormat( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal style As NamedStyle, _ ByVal op As ComparisonOperator, _ ByVal value As String _ ) As Boolean

Visual Basic (Declaration)

Public Overloads Function SetConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal style As NamedStyle, _
   ByVal op As ComparisonOperator, _
   ByVal value As String _
) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As SheetView Dim row As Integer Dim column As Integer Dim style As NamedStyle Dim op As ComparisonOperator Dim value As String Dim value As Boolean value = instance.SetConditionalFormat(row, column, style, op, value)

Visual Basic (Usage)

Copy Code

Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim style As NamedStyle
Dim op As ComparisonOperator
Dim value As String
Dim value As Boolean
 
value = instance.SetConditionalFormat(row, column, style, op, value)

C#
public bool SetConditionalFormat( int row, int column, NamedStyle style, ComparisonOperator op, string value )

Parameters

row: Row index of the cell
column: Column index of the cell
style: Style to be applied to the cell if the condition is satisfied
op: Comparison operator to apply to the cell value and the specified value
value: String with the specified value

Return Value

Boolean: true if successful; false otherwise

Example

This example changes the color of the cell if the value is greater than 14.

C#	Copy Code
FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle(); ns.BackColor = Color.Crimson; ns.Name = "mystyle"; FpSpread1.NamedStyles.Add(ns); FpSpread1.Sheets[0].SetConditionalFormat(0, 0, ns, FarPoint.Web.Spread.ComparisonOperator.GreaterThan, "14");

Copy Code

FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle();
        ns.BackColor = Color.Crimson;
        ns.Name = "mystyle";
        FpSpread1.NamedStyles.Add(ns);
        FpSpread1.Sheets[0].SetConditionalFormat(0, 0, ns, FarPoint.Web.Spread.ComparisonOperator.GreaterThan, "14");

Visual Basic	Copy Code
Dim ns As New FarPoint.Web.Spread.NamedStyle ns.BackColor = Drawing.Color.Azure ns.Name = "mystyle" FpSpread1.NamedStyles.Add(ns) FpSpread1.Sheets(0).SetConditionalFormat(0, 0, ns, FarPoint.Web.Spread.ComparisonOperator.GreaterThan, "14")

Visual Basic

Copy Code

Dim ns As New FarPoint.Web.Spread.NamedStyle
        ns.BackColor = Drawing.Color.Azure
        ns.Name = "mystyle"
        FpSpread1.NamedStyles.Add(ns)
        FpSpread1.Sheets(0).SetConditionalFormat(0, 0, ns, FarPoint.Web.Spread.ComparisonOperator.GreaterThan, "14")

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Syntax

Parameters

Return Value

Example

Requirements

See Also

Reference