Apply Shading

The Fill icon on the Home Tab/Font Group allows you to apply colors and patterns to the selected cell(s).

To apply colors:

Select cells to be shaded.

Navigate to the Borders and Shading group of the Formatting Palette.

Select the desired pattern, then select the appropriate fill color.

The selected cells are now filled with the selected color.