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.
The cells that contain missing values are shaded yellow.