Applying Shading

The Fill tab on the Format Cells dialog box allows you to apply colors and patterns to the selected cell(s). This tab offers the following options for color and patterns:

To apply colors and patterns:

1. Navigate to the Home Tab/Font Group pull down arrow.
   
2. The Format Cells dialog box will appear.
3. Click on the Patterns tab.
   • Select a color of cell shading.
   • Choose the down arrow button to display different pattern styles.’
   • Select a pattern.
   • Select a pattern color.
4. Click OK.

EXCEL EXTRAS

You can also use the Fill Color icon Fill Icon on Home Tab/Font Group to shade cells.