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.
The three cells that represent the lowest 10% income are shaded red.