Graphic1

Exam 77-428 Microsoft Excel 2013 EXPERT
2. Apply Custom Formats and Layouts
2.3 Apply Custom Styles and Templates: Create and Modify Cell Styles

pic1

Create a Custom Color Format

Excel has several Cell Styles including Good, Bad, Neutral, Data Model, Titles and Headings and Themed. The Styles format the Number, Alignment, Font, Border, Fill and Protection.

We played with the Cell Styles in some of the beginning lessons. This example looks at creating a Custom Color Format.

 

2. Try it: Create a New Cell Style

Type the Style Name: MyStyle
Click Format...

The Format Cells window should open.

Keep going...

Home ->Styles->Cell Styles->New Cell Style...

 

Graphic3