Microsoft Excel Functions & Formulas

Use the LARGE function to find the three

largest values

The three largest values in a range need to be found and shaded,

regardless of how many times they appear. Use the LARGE func-

tion to determine the three largest values in a range and specify

those three conditions as criteria for conditional formatting.

4

To search for and shade the three largest values:

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

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

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type the following formula:

=A1=LARGE($A$1:$E$10,1).

4. Click Format.

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