Microsoft Office Tutorials and References
In Depth Information
Highlighting Cells with Conditional Formats
Figure 2-35
Conditional formats highlight the bottom 10 percent of sales increases
cells highlighted
in red ran k in the
bottom 10 percent
in sales increases
Tom immediately sees that the bottom 10 percent come from only regions R02 and
R05, and that six of the nine cells highlighted occurred in the most recent months:
October, November, and December. Conditional formatting helped Tom isolate and
highlight potential problem areas, which he can investigate further.
When you use conditional formatting to highlight cells in a worksheet, you should
always include a legend , which is a key that shows each color used in the worksheet and
what it means, so others know why certain cells are highlighted. You will add a legend to
the Monthly Sales worksheet.
To create a conditional formatting legend:
1. In cell D51, type light red , and then click cell D51 to make it the active cell. You
will use a highlight rule to fill this cell with the light red color used for the bottom
10 percent sales increases.
2. In the Styles group on the Home tab, click the Conditional Formatting button,
point to Highlight Cells Rules , and then click Text that Contains . The Text That
Contains dialog box opens.
3. Verify that light red appears in the Format cells that contain the text box, select
Light Red Fill with Dark Red Text in the with box, and then click the OK button.
Cell D51 is filled with the same light red fill color used for the bottom 10 percent
values.
4. In cell D52, type light green , and then click cell D52 to make it the active cell.
You will use a highlight rule to fill this cell with the green color used for the top
10 percent sales increases.
5. In the Styles group, click the Conditional Formatting button, point to Highlight
Cells Rules , and then click Text that Contains . The Text That Contains dialog
box opens.
Search JabSto ::




Custom Search