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)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

TextConditionalFormattingRule Class
TextConditionalFormattingRule Members
Overload List