bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Formatting > Cell Formatting > Changing Cell Colors

Changing Cell Colors

Summary: There are two ways that you can fill a cell with a color. The first is to use the Fill Color tool from the Formatting toolbar, and the other is to use the Patterns tab of the Format Cells dialog box. Both methods are described in detail in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel includes a tool on the toolbar that allows you to quickly change the color of a selected cell. The Fill Color tool has a small bucket and color sample on it. This tool actually has two parts: If you click on the left part (the part with the small bucket and color sample), then the color shown in the sample is applied to the cells you have selected. Note that the color of the font doesn't change, only the color of the cell background. If you click on the arrow at the right side of the tool, you will see a color palette appear.

To select a color, click your mouse on one of the small color squares. This is applied to the cells you have selected and appears in the underline bar on the Fill Color tool.

Another method of changing cell color is as follows:

  1. Select the cells whose color you want to change.
  2. Choose the Cells option from the Format menu. You will see the Format Cells dialog box.
  3. Make sure the Patterns tab is selected. (Click here to see a related figure.)
  4. Using the color palette in the dialog box, select a cell color.
  5. Click on OK.

Tip #2757 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)