Example of formatting cells that contain the lowest values

A bank collects the following 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 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.
  3. Right-click, then choose Conditional Formatting > High/Low > Lowest Percentage.
  4. From Percent, select 10.
  5. Click OK.

Results

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