Apply Colors and Shading to Cells in Excel 2007

by rhyttinen on June 2, 2009

Font Color and Fill Color buttons in Excel 2007

To add some pizzazz to your worksheet or to make a particular cell or cell range stand out, you can apply patterns and background colors to the cells in your worksheet. Background color options are located under the Fill tab of the Format Cells Dialog box (you can also click the Fill Color button on the Home Ribbon on the Font group then choose the desired background color from the color palette). Additionally, you can change the color of the fonts in your worksheet by changing the foreground color of a selected cell or cell range. Excel’s Color Palette provides a wide variety of colors from which to choose.

To Apply a Background Color to Cells

  1. Select the cell or range of cells to which you want to apply a color.
  2. Click the Font Dialog Launcher.
  3. Click the Fill tab.
  4. Choose a color from the Color Palette.
  5. If desired, choose a Pattern from the Pattern Style drop-down list.
  6. To blend the color of your pattern with another color, select the additional color from the color palette in the Pattern Color drop-down list.
    OR
  1. Select the cell or cell range to which you want to apply a color.
  2. Click on the arrow to the right of the Fill Color Palette button on the Home Ribbon.
  3. Select the background color from the Color Palette.

To Change the Font Color

  1. Select the cell or range of cells to which you want to apply a font color.
  2. Click the Font Dialog Launcher.
  3. Click the Font tab.
  4. From the Color list box, choose a color from the Color Palette.
  5. Click OK.
    OR
  1. Select the cell or range of cells to which you want to apply a font color.
  2. Click the arrow to the right of the Font Color Palette Button on the Home Ribbon.
  3. Click on the desired font color.
Font tab of the Format Cells dialog box in Excel

Font tab of the Format Cells dialog box

Similar Posts:

Share and Enjoy:
  • del.icio.us
  • Digg
  • TwitThis
  • Reddit
  • Technorati
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • Propeller
  • email

Leave a Comment

Previous post:

Next post: