FormatCondition.TextOperator procedure builder

FormatCondition.TextOperator (Excel)

Returns or sets one of the constants of the XlContainsOperator enumeration, specifying the text search performed by the conditional formatting rule.

Possible Values are xlBeginsWith - Begins with a specified value, xlContains - Contains a specified value, xlDoesNotContain - Does not contain the specified value, xlEndsWith - Endswith the specified value.
ActiveCell.FormatConditions(1).TextOperator = xlBeginsWith