TextConditionalFormattingRule Constructor(TextConditionOperator,String,Boolean,Boolean)

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal op As TextConditionOperator, _
   ByVal text As String, _
   ByVal isFormula As Boolean, _
   ByVal suppressCustomName As Boolean _
)

'Usage
 
Dim op As TextConditionOperator
Dim text As String
Dim isFormula As Boolean
Dim suppressCustomName As Boolean
 
Dim instance As New TextConditionalFormattingRule(op, text, isFormula, suppressCustomName)

public TextConditionalFormattingRule( 
   TextConditionOperator op,
   string text,
   bool isFormula,
   bool suppressCustomName
)

Parameters

op: The operator.
text: The text.
isFormula: if set to true, the text parameter represents a formula; otherwise, it represents a normal text value.
suppressCustomName: true indicates that the expression, referred to by a custom name, will not be restricted; otherwise, false

This example creates a text rule.

C#

FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", true, false);
// Cell (1,1) must contain the text you type in C1            
text.BackColor = Color.Red;
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text);

Visual Basic

Dim Text As New FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", True, False)
' Cell (1,1) must contain the text you type in C1            
Text.BackColor = Color.Red
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, Text)

Reference

TextConditionalFormattingRule Class
TextConditionalFormattingRule Members
Overload List