Tuesday, December 30, 2008

Use Conditional Formatting to Highlight Above-Average Values

Highlighting exeptional values can be a useful (and simply-done) analysis tool. Here is an easy way to highlight the Above-Average values in a range:

  1. At the bottom of your range, enter the formula for Average: =Average(range)
  2. Select the values in the range (not including the Average formula)

  3. On the Home tab in Excel 2007, choose Conditional Formatting from the Styles menu

  4. Select Highlight Cells Rules / Greater Than

  5. Choose the dialogue box and click on the cell in which you have the Average Formula

  6. Choose the Formatting you wish to apply

  7. Click Enter and Presto! Values that are Above-Average are highlighted!

Use this simple method to highlight Above-Average values (You will be Above-Average Yourself!)

No comments: