Using Smart View Formatting (Cell Styles)

Smart View formatting, or cell styles, consists of formatting selections made in the Formatting tab in the Smart View Options panel. If you do not enable cell styles, then Excel formatting is used (see Using Excel Formatting).

To set Smart View formatting options:

1. From the Smart View ribbon, click the Options button:.

   
   
   

2. In the Options panel, select the Formatting tab.
3. In the Formatting tab, select Use Cell Styles.

4. Set the desired cell styles:

   1. In the Formatting tab, click the Cell Styles button to launch the Cell Styles panel.

      Note the three groupings of cell styles: Member Styles, Data Styles, and Miscellaneous Styles. In this example, Data Styles is expanded to show the available data types to which you can apply or change cell styles. The example show these available styles: Dirty, Cell Text, Attachment, Drill-through, Supporting Details, Read-only, and Data.

      
      
      

   2. Expand a cell style category and locate and click a cell style to change.

      For example, in the Data Styles category, you may select Attachment.

   3. Drag the color controls (the circles in the top left corner of each color block) till you arrive at the color you want.

      Following is the default color control. Move the bottom circle to choose a color category and move the top circle to choose a color shade within that category:

      
      
      

      Following is an example of changing the color to a category and shade of blue:

      
      
      

   4. When finished, click the X in the top right corner to close the pane and return to the Cell Styles panel.

5. In the Cell Styles panel, click Done to return to the Options panel, and then click the X in the top right corner to close the Options panel.