Microsoft Office Tutorials and References
In Depth Information
Changing the appearance of data
Changing the appearance of data
based on its value
By recording package volumes, vehicle miles, and other business data in a worksheet, you
can make important decisions about your operations. As explained earlier in this chapter,
you can change the appearance of data labels and the worksheet itself to make interpreting
your data easier.
Another way you can make your data easier to interpret is to have Excel change the
appearance of your data based on its value. These formats are called conditional formats because
the data must meet certain conditions, defined in conditional formatting rules, to have a
format applied to it. For example, if chief operating officer Lori Penor wanted to highlight
any Thursdays with higher-than-average weekday package volumes, she could define a
conditional format that tests the value in the cell recording total sales and changes the
format of the cell’s contents when the condition is met.
To create a conditional format, you select the cells to which you want to apply the format,
display the Home tab, and then in the Styles group, click Conditional Formatting to
display a menu of possible conditional formats. In Excel, you can define conditional formats
that change how the program displays data in cells that contain values above or below the
average values of the related cells, that contain values near the top or bottom of the value
range, or that contain values duplicated elsewhere in the selected range.
When you select which kind of condition to create, Excel opens a dialog box that
contains fields and controls that you can use to define your rule. To display all of the rules for
the selected cells, display the Home tab, and then in the Styles group, click Conditional
Formatting. On the menu, click Manage Rules to display the Conditional Formatting Rules
Manager dialog box.
Search JabSto ::

Custom Search