ExcelScript.ConditionalFormatPresetCriterion enum
Represents the criteria of the preset criteria conditional format type.
/**
* This script applies a conditional format that uses a preset criterion.
* Any cell in row 1 will have the color fill set to green if it is a duplicate value
* (of anything else in row 1).
*/
function main(workbook: ExcelScript.Workbook) {
// Get the range for row 1.
const sheet = workbook.getActiveWorksheet();
const formattedRange = sheet.getRange("1:1");
// Add new conditional formatting to that range.
const conditionalFormat = formattedRange.addConditionalFormat(
ExcelScript.ConditionalFormatType.presetCriteria);
// Set the conditional formatting to apply a green fill.
const presetFormat = conditionalFormat.getPreset();
presetFormat.getFormat().getFill().setColor("green");
// Set a rule to apply the conditional format when values are duplicated in the range.
const duplicateRule: ExcelScript.ConditionalPresetCriteriaRule = {
criterion: ExcelScript.ConditionalFormatPresetCriterion.duplicateValues
};
presetFormat.setRule(duplicateRule);
}
aboveAverage | |
belowAverage | |
blanks | |
duplicateValues | |
equalOrAboveAverage | |
equalOrBelowAverage | |
errors | |
invalid | |
lastMonth | |
lastSevenDays | |
lastWeek | |
nextMonth | |
nextWeek | |
nonBlanks | |
nonErrors | |
oneStdDevAboveAverage | |
oneStdDevBelowAverage | |
thisMonth | |
thisWeek | |
threeStdDevAboveAverage | |
threeStdDevBelowAverage | |
today | |
tomorrow | |
twoStdDevAboveAverage | |
twoStdDevBelowAverage | |
uniqueValues | |
yesterday |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Scripts feedback
Office Scripts is an open source project. Select a link to provide feedback: