Microsoft Excel Functions & Formulas

Use the MAX function to find the largest value

This example shows how to find and automatically mark the largest

value in a range. All occurrences of the largest value will be shaded.

Use the MAX function to determine the largest value in a range and

then use that value as the formatting criterion for conditional

formatting.

4

To search for and shade the largest value:

1. In a worksheet, enter numbers in cells A1:E10 (or copy the

values in Figure 10-8) and select the range.

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type the following formula:

=A1=MAX($A$1:$E$10).

4. Click Format.

5. From the Patterns tab, select a color ...