Example of formatting cells that contain values greater than the specified value

An engineer at a medical company measures the systolic blood pressure of a random sample of 60 people, using two monitors. The engineer wants to identify blood pressure measurements of greater than 139, which are considered high.

The engineer uses conditional formatting to identify the cells that contain values greater than 139.

  1. Open the sample data, BloodPressure.MTW.
  2. Drag to select cells in the New and Current columns.
  3. Choose Editor > Conditional Formatting > Highlight Cell > Greater Than.
  4. In Format cells that are greater than, enter 140.
  5. Click OK.

Results

Nine rows are shaded red. Both monitors correctly identify the patients who have high blood pressure.

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