Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
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
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Newest Tips
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
Changing Cell Colors
Summary: If you need to change the color with which a particular cell is filled, the easier method is to use the Fill Color tool, as described in this tip. That isn't the only way to fill cells, however. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)Excel includes a tool that allows you to quickly change the color of a selected cell. The Fill Color tool (available on the Formatting toolbar or on the Home tab of the ribbon) 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 color sample on the Fill Color tool.
Another method of changing cell color is as follows:
- Select the cells whose color you want to change.
- Display the Format Cells dialog box. (In versions of Excel before Excel 2007 choose the Cells option from the Format menu. In Excel 2007 press Ctrl+Shift+F.)
- Make sure the Patterns tab or, in Excel 2007, the Fill tab is selected. (Click here to see a related figure.)
- Using the color palette in the dialog box, select a cell color.
- Click on OK.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2757) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.Check out ExcelTips: The Macros today!