December 2007
Beginner
512 pages
11h 44m
English
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 2007 change the appearance of your data based on its value. These formats are called conditional formats because the data must meet certain conditions to have a format applied to it. For instance, if chief operating officer Jenny Lysaker wanted to highlight any Thursdays with higher-than-average weekday package volumes, she could define ...
Read now
Unlock full access