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

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article has been archived. It is offered "as is" and will no longer be updated.
INTRODUCTION
This article describes how to change the color of the smallest value in a range of cells in Microsoft Office Excel 2003.
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.
excel2003 excel2k3 xl2003 xl2k3 minimum value
Properties

Article ID: 909845 - Last Review: 01/16/2015 15:34:32 - Revision: 1.2

  • Microsoft Office Excel 2003
  • kbnosurvey kbarchive kbformula kbformat kbhowto KB909845
Feedback