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:

• Creating Your Own Conditional Formatting Rules in Excel 2007
• Using Conditional Formatting in Excel 2007
• Managing Conditional Formatting in Excel 2007
• Applying Specialized Conditional Formatting in Excel 2007
• Using Data Validation in Excel 2007
• Using Rules in Outlook 2007
• Using the AutoSum Button in Excel

Tagged as: Excel Tips, Microsoft Office Tips