Example of formatting cells that contain the lowest values

A bank requires eight pieces of information from loan applicants: income, education level, age, length of time at current residence, length of time with current employer, savings, debt, and number of credit cards. A bank administrator wants to analyze this data to determine the best way to group and report it. The administrator collects the information for 30 loan applicants.

The administrator uses conditional formatting to identify the applicants in the lowest 10% for income.

  1. Open the sample data, LoanApplicant.MTW.
  2. Click in the Income column. Right-click and choose Conditional Formatting > High/Low > Lowest Percentage.
  3. In Percent, select 10.
  4. Click OK.

Results

The three cells that represent the lowest 10% income are shaded red.

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