Microsoft KB Archive/909845

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

Article ID: 909845

Article Last Modified on 11/21/2005

-

APPLIES TO


 * Microsoft Office Excel 2003

-



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:  Determine the range of cells. This example uses the cell range of B2:H2. Click cell B2. On the Format menu, click Conditional Formatting. In the Condition 1 list, click Formula Is. 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. Click Format. On the Font tab, click a color in the Color list.</li> Click OK to close the Format Cells dialog box.</li> Click OK to close the Conditional Formatting dialog box.</li> Make sure that cell B2 is selected, and then click Copy on the Edit menu.</li> Select the cell range that you specified in step 5. For example, select the cell range of B2:H2.</li> On the Edit menu, click Paste Special.</li> In the Paste Special dialog box, click Formats under Paste, and then click OK.</li> Press ESC to quit the cell copy.</li> Type the following values in the cell range: <ul> B2: 2</li> C2: 3</li> D2: 5</li> E2: 6</li> F2: 8</li> G2: 1</li> H2: 9</li></ul> </li></ol>

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

Additional query words: excel2003 excel2k3 xl2003 xl2k3 minimum value

Keywords: kbformula kbformat kbhowto KB909845

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.