Using Conditional Formatting based on Top/Bottom Values in Excel 2007

In a previous post, we looked at using conditional formatting in Excel based on the cell’s value. Excel 2007 also allows you to apply quick conditional formatitng to the contents of cells based upon top or bottom ranked values or those cells that are below or above average.

The available comparison rules are:

• Top 10 Items
• Top 10%
• Bottom 10 Items
• Bottom 10%
• Above Average
• Below Average

To customize or create your own formatting rules, click More Rules from the Top/Bottom Rules menu and make your choices.

To Use Conditional Formatting based on Top/Bottom Values

1. Select the cell range you wish to format.
2. Click the Home tab on the Ribbon.
3. Click the Conditional Formatting button on the Home Ribbon and then point to Top/Bottom Rules.
4. Click the comparison rule from the list that you want to apply to the selected data
5. Enter any criteria in the comparison rule dialog box.
6. Click OK.

Similar Posts:

None Found

Tagged as: Excel 2007 Tips, Microsoft Office Tips