Highlight

Highlight formulas, constants, named cells and errors.

Input Parameters/Data

Sheet: Works on any sheet of the workbook.

Cells are format filled as follows:

  • FormulasCells with formulas.
  • ConstantsCells with numbers.
  • NamesNamed cells or ranges.
  • ErrorsCells with errors.

Notes

Most runs are completed within 3s.

The number of impacted cells is provided.

Clears any regular or conditional format fill in the current sheet.

Output

Format Fill: Format fill of matching cells in current sheet.

View demo here

Learn the basics in 5 minutes with our Quick start guide. To make the most of Fontics, check out our Tips & tricks.