![]() Use the Style pop-up to choose the type of formatting you’d like to apply. This opens the New Formatting Rule window, which is where you define the rule. The Manage Rules window will appear click the plus sign at the bottom to add a new rule for your selected range. To get started, select the data range you’re interested in analyzing, then choose Format -> Conditional Formatting. Excel 2011 offers a lot of pre-defined conditional formats that can be used with a few mouse clicks. In the past, Conditional Formatting could do this, but you really had to work hard to get the most out of the feature. The greatly-improved Conditional Formatting feature in Excel 2011 is another good tool for revealing trends and key values in your data. Conditional Formatting reveals key values Sparklines show you trends in your data that you might otherwise miss. As with Themes, you can define and save your own Cell Styles, too, making it simple to apply a personal style to any cell. Highlight a cell, or range of cells, and click Styles to see a drop-down panel containing a number of pre-defined styles.įor instance, if you’ve got a range of data that you’re unsure of and want to check later, select the Check Cell style to turn those cells into double-outlined white-on-gray use the Note style to give the selection the appearance of a yellow sticky note. As with Themes, you’ll find Cell Styles on the Home tab of the Ribbon. Themes allow you to easily change the overall appearance of your worksheetĬell Styles Cell Styles are closely related to Themes, but work at the cell level instead of at the worksheet level. Create a custom theme using those fonts and colors, and you’re ready to go. This is ideal for those in corporate environments who may have required settings for fonts and colors in their worksheets. Note, too, that you can save your own theme by using the Save Theme option at the bottom of the theme chooser. To change your worksheet’s appearance, select a new theme.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |