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

Article translations Article translations
Article ID: 909845 - View products that this article applies to.
Expand all | Collapse all

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.

Properties

Article ID: 909845 - Last Review: November 21, 2005 - Revision: 1.2
APPLIES TO
  • Microsoft Office Excel 2003
Keywords: 
kbformula kbformat kbhowto KB909845

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com