Example of formatting cells that contain out-of-control values

A quality engineer at an automotive parts plant monitors the lengths of camshafts. Three machines manufacture camshafts for four shifts each day. The engineer measures five camshafts from each machine during each shift.

The engineer uses conditional formatting to identify out-of-control subgroups.

  1. Open the sample data, CamshaftLength.MTW.
  2. Choose Data > Conditional Formatting > Statistical > Out of Control.
  3. In Column, enter Machine 1.
  4. In Subgroup size, enter 5.
  5. Click OK.


Subgroup 8 (rows 36-40) is shaded red, which indicates that it is an out-of-control subgroup.

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