Edit

Share via

ExcelScript.SpecialCellType enum

Package:
ExcelScript

Remarks

Examples

/**
 * This script finds and highlights all the cells in the current worksheet that contain a formula.
 */
function main(workbook: ExcelScript.Workbook) {
  // Get the used range on the current sheet.
  const currentSheet = workbook.getActiveWorksheet();
  const usedRange = currentSheet.getUsedRange();

  // Get the RangeAreas object for each cell with a formula.
  const formulaCells = usedRange.getSpecialCells(ExcelScript.SpecialCellType.formulas);

  // Add a light blue background to the cells containing formulas.
  formulaCells.getFormat().getFill().setColor("#ADD8E6");
}

Fields

blanks

Cells with no content.
conditionalFormats

All cells with conditional formats.
constants

Cells containing constants.
dataValidations

Cells with validation criteria.
formulas

Cells containing formulas.
sameConditionalFormat

Cells with the same conditional format as the first cell in the range.
sameDataValidation

Cells with the same data validation criteria as the first cell in the range.
visible

Cells that are visible.