• Formatting
  • About Cell Formatting
  • Conditional Formatting
  • Adjusting Cell Height
  • Adjusting Cell Width
  • Aligning a Column of Cells
  • Aligning Numbers and Text in a Cell
  • Capitalizing Cell Contents
  • Changing a Cell's Font
  • Changing a Cell's Type
  • Changing The Separator for Date Cells
  • Creating a User Defined Underline
  • Defining Cell Options Globally
  • Distributing Cell Contents Evenly
  • Formatting The Appearance of Negative Values
  • Formatting The Appearance of Positive Values
  • Formatting The Appearance of Zero Values
  • Printing a Currency Sign Inside a Cell
  • Separating Large Currency Values with a Comma
  • Shading a Cell
  • Shading a Column of Cells in Form Mode
  • Shading Multiple Cells
  • Underlining a Cell
  • Underlining The Currency Symbol

Shading a Cell

1. Select the cell you want to modify.

2. On the Home tab, click Cell, and then click Formatting.

3. In the Type list, select a pattern for the shading.
4. In the Color list, select a color for the shading. To create a custom color, select Other from the drop-down list and create a customized color.
5. Select any other shading options, such as shading currency signs or brackets.

6. Click OK.

Tip: You can access a cell-formatting menu by right-clicking on the cell, and selecting a Shading option.

Related Topics

• About Cell Formatting