Public Overloads Function SetConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal style As NamedStyle, _
   ByVal op As ComparisonOperator, _
   ByVal firstCondition As Expression, _
   ByVal lastCondition As Expression _
) 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 Expression
Dim lastCondition As Expression
Dim value As Boolean
 
value = instance.SetConditionalFormat(row, column, style, op, firstCondition, lastCondition)

public bool SetConditionalFormat( 
   int row,
   int column,
   NamedStyle style,
   ComparisonOperator op,
   Expression firstCondition,
   Expression 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