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

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

public virtual bool SetConditionalFormat( 
   int row,
   int column,
   NamedStyle style,
   ComparisonOperator op,
   string firstCondition,
   string lastCondition
)

FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle(); 
FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.Spread.NamedStyle();

styleCold.BackColor = Color.Blue;
styleCool.BackColor = Color.Cyan;

FarPoint.CalcEngine.Expression one; FarPoint.CalcEngine.Expression two; 
one = new FarPoint.CalcEngine.DoubleExpression(20.0);
two = new FarPoint.CalcEngine.DoubleExpression(50.0); 

FarPoint.Win.Spread.Model.DefaultSheetStyleModel ds;
ds = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Mode ls.Style;
ds.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.Between, "5", "20"); 
ds.SetConditionalFormat(2, 2, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, one, two);

fpSpread1.ActiveSheet.Cells[1, 1].Value = 10; 
fpSpread1.ActiveSheet.Cells[2, 2].Value = 32;

Dim styleCold As New FarPoint.Win.Spread.NamedStyle
Dim styleCool As New FarPoint.Win.Spread.NamedStyle

styleCold.BackColor = Color.Blue
styleCool.BackColor = Color.Cyan

Dim one As FarPoint.CalcEngine.Expression
Dim two As FarPoint.CalcEngine.Expression
one = New FarPoint.CalcEngine.DoubleExpression(20.0)
two = New FarPoint.CalcEngine.DoubleExpression(50.0)

Dim ds As FarPoint.Win.Spread.Model.DefaultSheetStyleModel
ds = FpSpread1.ActiveSheet.Models.Style
ds.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.Between, "5", "20") 
ds.SetConditionalFormat(2, 2, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, one, two)

FpSpread1.ActiveSheet.Cells(1, 1).Value = 10 FpSpread1.ActiveSheet.Cells(2, 2).Value = 32