How to change the color of the smallest value in a range of cells in Excel 2003 (909845)

MORE INFORMATION

To change the color of the smallest value in a cell range, follow these steps:

1. Determine the range of cells. This example uses the cell range of B2:H2.
2. Click cell B2.
3. On the Format menu, click Conditional Formatting.
4. In the Condition 1 list, click Formula Is.
5. Press the TAB key, and then type the following formula:

   =IF(ISBLANK(B2),FALSE,MIN($B2:$H2)=B2)

   Note In this example, the cell range is B2:H2. Substitute the cell range that you want in the formula.
6. Click Format.
7. On the Font tab, click a color in the Color list.
8. Click OK to close the Format Cells dialog box.
9. Click OK to close the Conditional Formatting dialog box.
10. Make sure that cell B2 is selected, and then click Copy on the Edit menu.
11. Select the cell range that you specified in step 5. For example, select the cell range of B2:H2.
12. On the Edit menu, click Paste Special.
13. In the Paste Special dialog box, click Formats under Paste, and then click OK.
14. Press ESC to quit the cell copy.
15. Type the following values in the cell range:
    • B2: 2
    • C2: 3
    • D2: 5
    • E2: 6
    • F2: 8
    • G2: 1
    • H2: 9

Notice that the value in G2 changes to the color that you specified in step 7.