1. Home
  2. Colouring Missing Value Cells

Colouring Missing Value Cells

Temporary missing values are cells that have been temporarily marked as ‘missing’ to exclude them from an analysis. You can customize the cell background colour and text colour of these cells.

  1. From the menu select Tools | Spreadsheet Options then click the Appearance tab.

  2. Select Temporarily missing cells to change the text colour or Temporarily missing cells background to change the background cell colour.
  3. Click the Colour dropdown list and select a colour or click Custom to use the colour palette.
  4. Click OK to apply the colour.
Updated on December 14, 2018

Was this article helpful?