This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Cell Formatting - Shade a Cell with a Pattern

To help a particular cell in a Microsoft Excel 2003 spreadsheet stand out from the rest, you can shade the cell's background with a variety of colored patterns, such as diagonal lines, crosshatches, or dots.

1. Right-click on a cell or cells to apply a pattern to and choose "Format Cell".

2. When the "Format Cells" multi-tabbed dialog box appears, click the "Patterns" box.

3. To completely shade a cell with a particular color, click the desired color from the selection of colors directly underneath "Cell shading".

4. Or, apply a patterned fill to the cell. Click a color from the bottom two rows of boxes. Then, click the "Pattern" pull-down and choose from a variety of patterns. Here, you can also choose other colors for the pattern.

5. When done, click "OK" to close the dialog box and apply your changes.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Cell Formatting - Shade a Cell with a Pattern.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.