Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change cell fill color options
Is there any way to change the color selections available under the Format
Cells dialog, Fill tab? I know I can pick any specific color by clicking the More Colors button for a particular cell, but I would like to change the entire table of options available on the main Fill tab to show variations of colors that are more bold. Hope this makes sense. I appreciate your help, -John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change cell fill color options
First, these color settings are workbook level settings--not application
settings. So for each workbook you want to change... Tools|Options|Color tab select the color and click modify. Save your workbook with the new colors. (Notice that there's a reset button on that dialog. You can use that when you're ready <bg.) For new workbooks... Saved from a previous post: You could create a workbook template named book.xlt and store it in your XLStart folder. You can name the sheets whatever you want (and do other stuff, too -- print headers/footers/margins). In xl2003, a new workbook will be created based on this workbook when you click on the New Icon on the standard toolbar. For lots of settings... You could also create another template named sheet.xlt. Any new worksheet you add to an existing workbook will inherit its setting. John wrote: Is there any way to change the color selections available under the Format Cells dialog, Fill tab? I know I can pick any specific color by clicking the More Colors button for a particular cell, but I would like to change the entire table of options available on the main Fill tab to show variations of colors that are more bold. Hope this makes sense. I appreciate your help, -John -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Fill Color change for MAX value | Excel Worksheet Functions | |||
Text & Fill color options from older version? | Excel Discussion (Misc queries) | |||
excel 2007 - change fill color from one color to another | Excel Discussion (Misc queries) | |||
How do I get more color options for fill in for cells, excel 2003? | Excel Worksheet Functions | |||
How do I change fill color in excel based on data in the cell | Excel Worksheet Functions |