» Applying Colors to Top/Bottom Values in a List in Excel 2007

To color the top/bottom values in the entire List:

1. Select a cell in the List and press Ctrl+Shift+* or press Ctrl+A to select the List.
2. Select Home -> Conditional Formatting (in Styles Group) -> Top/Bottom Rules -> Top N Items.
3. In Format cells that rank in the Top select a number, select the formatting from with dropdown list, and click OK.
4. Repeat the steps above to format the Bottom N Numbers.



To color the top/bottom values in a column:

1. Select a column in the List.
2. Follow the steps above.
 To color rows where maximum/minimum values are ,in a specific column:
1. Select a cell in the List and press Ctrl+Shift+* or press Ctrl+A.
2. Select Home -> Conditional Formatting (in Styles Group) -> New Rule.
3. Select Use a Formula to determine which cells to format.
4. In Format values where this formula is true insert the formula =MAX($F:$F) =$F1, click the Format button, select the Fill tab, choose a color and click OK.
5. Add a new rule while changing the formula to calculate the minimum number,
=MIN($F:$F) =$F1.



Note:
Be sure to distinguish between Absolute reference and Relative reference when entering the formulas.