Conditional formatting can help you get the information you
need from data. For example, suppose you would like to know how many students
in your class received an above-average score on a recent exam. You’ve listed
their exam scores next to their names in the range L2:L24. To identify the
above-average students in your class, follow these steps:
- Select L2:L24.
to Format: Conditional Formatting.
the drop-down arrow and select Formula Is.
the following formula:
the Format button.
Red in the drop-down Color menu.
All above-average scores will be red.
Note: When entering the
formula in step 4, ensure that the cell references in the Average function are
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.