ExcelScript.TextConditionalFormat interface

Remarks

Used by

• ExcelScript.ConditionalFormat: getTextComparison

Examples

/**
 * This script adds conditional formatting to the first column in the worksheet.
 * This formatting gives the cells a green fill if they have text starting with "Excel".
 */
function main(workbook: ExcelScript.Workbook) {
 // Get the first column in the current worksheet.
 const currentSheet = workbook.getActiveWorksheet();
 const firstColumn = currentSheet.getRange("A:A");

 // Add conditional formatting based on the text in the cells.
 const textConditionFormat: ExcelScript.TextConditionalFormat = 
 firstColumn.addConditionalFormat(ExcelScript.ConditionalFormatType.containsText).getTextComparison();

 // Set the conditional format to provide a green fill.
 textConditionFormat.getFormat().getFill().setColor("green");

 // Apply the condition rule that the text begins with "Excel".
 const textRule: ExcelScript.ConditionalTextComparisonRule = {
 operator: ExcelScript.ConditionalTextOperator.beginsWith,
 text: "Excel"
 };
 textConditionFormat.setRule(textRule);
}

Methods

getFormat()

getFormat(): ConditionalRangeFormat;

getRule()

getRule(): ConditionalTextComparisonRule;

setRule(rule)

setRule(rule: ConditionalTextComparisonRule): void;