EVALUATE PROFITABILITY USING MICROSOFT EXCEL

You have some products for sale and you want to know which one is the most profitable. Use conditional formatting for this purpose.

To determine the most profitable product:

1. In a new worksheet, type the cost of each product in column 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 click OK.

EVALUATE PROFITABILITY USING MICROSOFT EXCEL

Note: Product pr04 has the greatest profit margin as calculated in column D. The conditional formatting highlights the cell automatically.

Microsoft Excel Tutorials, Evaluate Profitability Using Microsoft Excel, Formulas in Excel, Video Tutorials of Excel, Microsoft Excel 2007 Macros