Microsoft Excel Functions & Formulas

Evaluate profitability

You have some products for sale and you want to know which one is

the most profitable. Use conditional formatting for this purpose.

4

To determine the most profitable product:

1. In a new worksheet, type the cost of each product in col-

umn B and the corresponding price in column C. You can

use your own data or the data shown in Figure 1-19.

2. Select cells D2:D6 and type the following formula:

=1-(B2/C2).

3. Press <Ctrl+Enter>.

4. From the Format menu, select Conditional Formatting.

5. As Condition 1, select Formula Is and type the following

formula: =D2=max($D$2:$D$6).

6. Click Format, select the Patterns tab, choose a color, and ...