Evaluate Profitability - Formulas In Excel - Microsoft Excel Tutorials

19.  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.

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.

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

Watch the Video Tutorial - https://www.youtube.com/watch?v=5jnO74fy0HM

Hope You Like This Tutorial - Give Comments