Excel – Basic Training - Shclearn.ppt

Adding Fill Color Using Cell Styles To Create a New Cell Style Highlight the cell or cell range where you want to apply your style. Select the Cell Styles tool from the Home tab of the Ribbon to see the style gallery. Select New Cell Style to open the Style dialog box. Enter a name for the style in the Style Name field. Check the Style Includes boxes to indicate what formatting features the style should include. The options vary based on the active cell. Select Format to open the Format Cells dialog box. Use the Format Cells dialog box to indicate each formatting feature for the style. Select OK when you have finished indicating all of the formatting features for the style. The Number tab allows you to set number formatting for cells that contain values. The Alignment tab allows you to set text alignment for cells that contain text. The Font tab allows you to set the font for the style. The Border tab allows you to set customized borders for the style. The Fill tab allows you to set customized fill color for the style. The Protection tab allows you to protect the cells from changes if you use the Protection feature. Select OK to save your style and close the Style dialog box. The new style appears at the top of the Cell Style gallery. Using Conditional Formatting Highlight the cell or cell range where you want to use conditional formatting. Select the Conditional Formatting tool from the Home tab on the Ribbon. Select New Rule. Excel opens the New Formatting Rule dialog box. The options in this dialog box differ, based on the Rule Type you select. Select the Rule Type and follow the prompts to indicate the conditions for when to apply the formatting. Select Format to open the Format Cells dialog box to create the formatting to apply when the conditions are met. Select OK to save your rule and close the New Formatting Rule dialog box. Changing the Theme Module Twelve: Wrapping Up Words from the Wise Remember to spend some time planning your worksheet. Be cl