Excel for Marketing Managers

Finding Maximum Area and Volume

Finding Max
Area and
volume

let them work individually at workstations or as a group with an overhead

projector.

Excel Extras

You can make the maximum value really pop out using conditional formatting.

1. In the calculation table, select the cells in the Area column, E15-E63. Select
   Format → Conditional Formatting.


2. Set the condition 1 cell value to “equal to”.


3. Type in the following formula in the last text box on the top: =$E$65


4. Press the Format... button and set the Pattern to Yellow. Click OK twice.


5. Excel highlights cell E39 because it matches the maximum value deter-
   mined by cell E65.

Figure 252

Setting conditional

formatting

parameters