Learn Excel 2011 for Mac

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 ...