Microsoft Excel Functions & Formulas

Use the MIN function to find the month with

the worst performance

Salespeople usually do some market analysis to find their current

share of the market. Before you can investigate the reasons for a

bad fiscal year, you need to find the worst month of sales and then

shade it. Use the MIN function to get the lowest value in a range

and use it as the formatting criteria for conditional formatting.

4

To search for the worst month:

1. In a worksheet, enter the months in cells A2:A13 and the

sales amounts in cells B2:B13 (or copy the values in Figure

10-10), and select the range.

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type ...