Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Use Conditional Formatting to Highlight Data Trends Conditional formatting can help you highlight trends in your data. First, either open a fully populated Microsoft Office Excel file, or start with an empty document and fill its cells with some values. To apply conditional formatting: 1. Click the Conditional Formatting button on the Home tab of the Ribbon. 2. On the menu that appears, try selecting Data Bars, Icon Sets, or Color Scales and pause over the options. Your data is partitioned according to the rules you set, and it instantly displays visual cues that will aid understanding of the data. 3. If you don't like the options available, you can create your own rules, use your own colors, and establish your own thresholds. Better still, you can reuse your rules each time for consistent and clear presentation. All of these options are available on the Conditional Formatting menu. Insert Pictures To insert a picture in your notes, click Insert, click Pictures, and then click either From Files or From Scanner or Camera. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement