AddTextCondition Method

Adds a new TextOperatorConditionalFormat instance to this collection.

Syntax

Visual Basic

'Declaration
 
Public Function AddTextCondition( _
   ByVal regionAddress As String, _
   Optional ByVal text As String, _
   Optional ByVal textOperator As FormatConditionTextOperator _
) As TextOperatorConditionalFormat

C#

public TextOperatorConditionalFormat AddTextCondition( 
   string regionAddress,
   string text,
   FormatConditionTextOperator textOperator
)

Parameters

regionAddress

A string identifying the region to which this conditional format applies.

text

A string which determines the string against which cell text values are evaluated. This parameter is optional and defaults to null.

textOperator

A FormatConditionTextOperator value which determines the manner in which cell values are compared to the text value. This parameter is optional and defaults to BeginsWith.

Return Value

The resulting TextOperatorConditionalFormat instance.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2