Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Customize the Appearance of Conditional Formats Such as Data Bars, Color Scales, and Icon Sets When you need conditional formatting in your Microsoft Office Excel 2007 worksheet, try one of the new data visualization options, including color scales, icon sets, and data bars. You can apply these formats with just a click from galleries of preset options, or customize your own conditional formatting rules. To access the new conditional formats, on the Home tab, in the Styles section, click Conditional Formatting, and then point to Data Bars, Color Scales, or Icon Sets. Or to create a custom rule for one of these formats, at the bottom of the Conditional Formatting menu, click New Rule. In the New Formatting Rule dialog box, select the rule type Format all cells based on their values to use the new data visualization tools. In the lower half of the box, you can then choose among data bars, color scales, and icon sets; specify conditions for each formatting type; and customize colors for data bars or color scales. Note: In Excel 2007, it's also possible to edit existing conditional formatting rules. To access existing rules for editing, at the bottom of the Conditional Formatting menu, click Manage Rules. Synchronizing Your Own Computers If you have multiple computers, you can set up your Microsoft Office Groove 2007 account on each of them to keep a synchronized copy of key workspaces and files on each computer. 1. From the File menu, click Use Account on Another Computer, and then save the account file to your desktop by clicking OK in the dialog box. 2. Transfer the account file to a second computer through an e-mail attachment or a removable storage device. 3. On the second computer, install Groove 2007. In the Account Configuration Wizard, click Use a Groove Account you have already created, and follow the instructions to select your saved account file. 4. Your workspaces will appear in the Launchbar labeled as Not on this computer. Double-click each workspace to download it from your other computer. Note: Your Groove administrator may have set policies for your account that restrict you from adding it to other computers. • 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