Microsoft Office Tutorials and References
In Depth Information
Highlighting Cells with Conditional Formats
Conditional formats highlight the top 10 percent sales increases
cells highlighted in
green rank in the
top 10 percent in
The results provide Tom with some interesting information. For example, region R08,
which underperformed for most of the year, had one of the largest sales increases during
April (cell J40). In fact, the increase in sales during that one month compensated for the
sales declines in other months; so that by the end of the year, region R08 showed no
overall decline in sales. Also, region R01 had a large increase in sales during January
2012 but demonstrated the same level of increase for the rest of the year. Finally, four of
the nine cells highlighted in the table are from region R07; three of those occurred
during the spring months, which are traditionally slow times for the company.
Tom wonders what insights he could gain from highlighting the bottom 10 percent of
the table—the regions and months that showed the lowest sales increases in 2012.
To highlight the bottom 10 percent in sales increases:
1. Select the range C37:J48 .
2. In the Styles group on the Home tab, click the Conditional Formatting button,
point to Top/Bottom Rules , and then click Bottom 10 % . The Bottom 10% dialog
3. Verify that is entered in the % box and Light Red Fill with Dark Red Text is 10
selected in the with box.
4. Click the OK button. Red cells highlight the regions and months that placed in the
bottom 10 percent for sales increases from 2011 to 2012.
5. Click cell A35 to deselect the range. See Figure 2-35.