ExcelScript.CustomConditionalFormat interface
Represents a custom conditional format type.
Remarks
Examples
/**
* This script applies a custom three-color conditional formatting to the selected range.
* The three colors represent positive, negative, or no changes from the values in the previous column.
*/
function main(workbook: ExcelScript.Workbook) {
// Get the selected cells.
let selectedRange = workbook.getSelectedRange();
// Apply a rule for positive change from the previous column.
let positiveChange = selectedRange.addConditionalFormat(ExcelScript.ConditionalFormatType.custom);
positiveChange.getCustom().getFormat().getFill().setColor("lightgreen");
positiveChange.getCustom().getRule().setFormula(`=${selectedRange.getCell(0, 0).getAddress()}>${selectedRange.getOffsetRange(0, -1).getCell(0, 0).getAddress()}`);
// Apply a rule for negative change from the previous column.
let negativeChange = selectedRange.addConditionalFormat(ExcelScript.ConditionalFormatType.custom);
negativeChange.getCustom().getFormat().getFill().setColor("pink");
negativeChange.getCustom().getRule().setFormula(`=${selectedRange.getCell(0, 0).getAddress()}<${selectedRange.getOffsetRange(0, -1).getCell(0, 0).getAddress()}`);
// Apply a rule for no change from the previous column.
let noChange = selectedRange.addConditionalFormat(ExcelScript.ConditionalFormatType.custom);
noChange.getCustom().getFormat().getFill().setColor("lightyellow");
noChange.getCustom().getRule().setFormula(`=${selectedRange.getCell(0, 0).getAddress()}=${selectedRange.getOffsetRange(0, -1).getCell(0, 0).getAddress()}`);
}
Methods
get |
Returns a format object, encapsulating the conditional formats font, fill, borders, and other properties. |
get |
Specifies the |
Method Details
getFormat()
Returns a format object, encapsulating the conditional formats font, fill, borders, and other properties.
getFormat(): ConditionalRangeFormat;
Returns
getRule()
Specifies the Rule
object on this conditional format.
getRule(): ConditionalFormatRule;
Returns
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
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for