
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
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.
Check out ExcelTips: Filters and Filtering today!
Add power to your purpose with Excel. A comprehensive 500+ page e-book explains everything you need to know about macros. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site