O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Identifying Unusual Values with Conditional Formatting

In many worksheets, it's useful to be able to monitor the values in the cells and to pick out values that stand out in particular ways. For example, you may want to see which ten products are bringing in the most revenue, or you may need an easy way to make unusually high values or unusually low values stand out from the others.

To monitor the values in a cell or a range, you can apply conditional formatting—formatting that Excel displays only when the condition is met. For example, if you're monitoring temperatures in Fahrenheit, you could apply conditional formatting to highlight low temperatures (say, below 20F) and high temperatures (say, above 100F). Temperatures in the normal range ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required