
Tips.Net > ExcelTips Home > Formatting > Cell Formatting > 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:
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!
Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
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