Example of formatting cells that contain missing observations

A quality engineer for a pharmaceutical company wants to determine the shelf life for pills that contain a new drug. The engineer collects a batch of pills from each of five production lines. The engineer tests one pill from each batch at nine different times. However, some of the samples are missing.

The engineer uses conditional formatting to identify the cells that contain the missing observations.

  1. Open the sample data, ShelfLife.MTW.
  2. Click in the Drug% column.
  3. Choose Editor > Conditional Formatting > Highlight Cell > Missing Observations.
  4. From Style, select Yellow.
  5. Click OK.

Results

The cells that contain missing values are shaded yellow.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy