TextConditionalFormattingRule Constructor(TextConditionOperator,String,Boolean)

Initializes a new instance of the TextConditionalFormattingRule class.

Syntax

Visual Basic
C#

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

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

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

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.

Example

This example creates a text rule.

FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", true);
// 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)
' 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