excel.conditionaltextoperator.yml

### YamlMime:TSEnum
name: Excel.ConditionalTextOperator
uid: 'excel!Excel.ConditionalTextOperator:enum'
package: excel!
fullName: Excel.ConditionalTextOperator
summary: Represents the operator of the text conditional format type.
remarks: >-
  \[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]


  #### Examples


  ```TypeScript

  // Link to full sample:
  https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/14-conditional-formatting/conditional-formatting-basic.yaml


  await Excel.run(async (context) => {
      const sheet = context.workbook.worksheets.getItem("Sample");
      const range = sheet.getRange("B16:D18");
      const conditionalFormat = range.conditionalFormats
          .add(Excel.ConditionalFormatType.containsText);
      conditionalFormat.textComparison.format.font.color = "red";
      conditionalFormat.textComparison.rule = { operator: Excel.ConditionalTextOperator.contains, text: "Delayed" };

      await context.sync();
  });

  ```
isPreview: false
isDeprecated: false
fields:
  - name: beginsWith
    uid: 'excel!Excel.ConditionalTextOperator.beginsWith:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"BeginsWith"'
  - name: contains
    uid: 'excel!Excel.ConditionalTextOperator.contains:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Contains"'
  - name: endsWith
    uid: 'excel!Excel.ConditionalTextOperator.endsWith:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"EndsWith"'
  - name: invalid
    uid: 'excel!Excel.ConditionalTextOperator.invalid:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"Invalid"'
  - name: notContains
    uid: 'excel!Excel.ConditionalTextOperator.notContains:member'
    package: excel!
    summary: '* \[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    value: '"NotContains"'