| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get custom colors for filling cells in Excel?
I'm trying to shade cells in an Excel sheet. However, there are only a few
colors to choose from and they're all quite dark/unattractive. How do I get more customized colors? I see it is possible to "mix" by using patterns, but that's quite clumsy I think. Are there any other methods of adding new colors? |
|
#2
|
|||
|
|||
|
yes, you can.
goto tooloptionscolor tabmodify buttoncustom tab here you can create you own custom colors. you are limited to 56 total. -----Original Message----- I'm trying to shade cells in an Excel sheet. However, there are only a few colors to choose from and they're all quite dark/unattractive. How do I get more customized colors? I see it is possible to "mix" by using patterns, but that's quite clumsy I think. Are there any other methods of adding new colors? . |
|
#3
|
|||
|
|||
|
David
ToolsOptionsColorsModify. Note: this is a workbook setting and will not be the default for all workbooks. You can copy the modified colors to another workbook if so desired. Same dialog "copy colors from". The modified workbook must be open. Gord Dibben Excel MVP On Fri, 28 Jan 2005 12:45:03 -0800, "David Grant" <David wrote: I'm trying to shade cells in an Excel sheet. However, there are only a few colors to choose from and they're all quite dark/unattractive. How do I get more customized colors? I see it is possible to "mix" by using patterns, but that's quite clumsy I think. Are there any other methods of adding new colors? |
|
#4
|
|||
|
|||
|
Thanks, anon. and Gord, your that was exactly what I needed. I appreciate
your quick responses. "Gord Dibben" wrote: David ToolsOptionsColorsModify. Note: this is a workbook setting and will not be the default for all workbooks. You can copy the modified colors to another workbook if so desired. Same dialog "copy colors from". The modified workbook must be open. Gord Dibben Excel MVP On Fri, 28 Jan 2005 12:45:03 -0800, "David Grant" <David wrote: I'm trying to shade cells in an Excel sheet. However, there are only a few colors to choose from and they're all quite dark/unattractive. How do I get more customized colors? I see it is possible to "mix" by using patterns, but that's quite clumsy I think. Are there any other methods of adding new colors? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
| EXCEL cells colors | Excel Discussion (Misc queries) | |||
| Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
Linear Mode
