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

A medical researcher measures the systolic blood pressure of a sample of 60 people, using two monitors. The researcher wants to identify blood pressure measurements that are greater than 139, which is considered high.

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

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

Results

Nine rows are shaded red. Both monitors identify high blood pressure readings for the same people.

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