Microsoft Office Tutorials and References
In Depth Information
16. In the Type list, click the #,##0 item.
#,##0 appears in the Type box.
17. In the Type box, click to the left of the existing format, and type $ . Then click to
the right of the format, and type “ before bonuses” (note the space after the
18. Click OK to close the dialog box.
CLEAN UP Save the ExecutiveSearch workbook, and then close it.
Changing the Appearance of Data
Based on Its Value
Recording package volumes, vehicle miles, and other business data in a worksheet enables
you to make important decisions about your operations. And as you saw 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.