You can add shading to cells by filling them with a solid color, a pattern color, a pattern style, or any combination of the three. If you have trouble printing the cell shading that you applied in color, verify that print options are set correctly.
You can remove cell shading if you no longer need it.
Fills cell with a solid color, pattern color, or pattern style
-
Select the cells that you want to fill.
-
Click the Format menu, and then click Cells.
-
In the Format Cells dialog box, click the Fill tab.
-
Format the selected cells using the following options:
-
In the Background color box, select a color.
-
In the Pattern color box, select a color for the lines of the pattern.
-
In the Pattern style box, select a pattern.
-
-
Click OK.
To remove a solid color, pattern color, or pattern style of selected cells, open the Format Cells dialog box, and clear the color or pattern selection.
