Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
custom fill problem in Excel 2003?
I know I've done this before, but Excel is not letting me create a custom
color for a fill. When I click on the toolbar dropdown, it gives me the palate, but no options for "more colors" like in word. I've done format, cell, patterns. No luck. I've right-clicked on the cell I wanted to change and selected format cells. Still only gives me the basic palate with no option for more colors. See screen shots he http://www.senseiouch.com/1.jpg http://www.senseiouch.com/2.jpg I can't find where to get those options; maybe I'm crazy but I'm sure they used to be on these screens. How do I get my color options back? Thanks for any help. Ben |
#2
|
|||
|
|||
Think you can modify the color palette via:
Tools Options Color tab Modify (there's even a "Reset" button to get back the defaults <g) The modified palette will then be available for use .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "bjcouch" wrote in message ... I know I've done this before, but Excel is not letting me create a custom color for a fill. When I click on the toolbar dropdown, it gives me the palate, but no options for "more colors" like in word. I've done format, cell, patterns. No luck. I've right-clicked on the cell I wanted to change and selected format cells. Still only gives me the basic palate with no option for more colors. See screen shots he http://www.senseiouch.com/1.jpg http://www.senseiouch.com/2.jpg I can't find where to get those options; maybe I'm crazy but I'm sure they used to be on these screens. How do I get my color options back? Thanks for any help. Ben |
#3
|
|||
|
|||
You get 56 colors in any workbook in excel.
You can change any of those 56 colors via tools|options|colors tab|modify button. (I don't think they've ever been on those dialogs--but I'm getting older and my memory fades more each day!) If you want to read more about colors and excel, visit David McRitchie's site: http://www.mvps.org/dmcritchie/excel/colors.htm bjcouch wrote: I know I've done this before, but Excel is not letting me create a custom color for a fill. When I click on the toolbar dropdown, it gives me the palate, but no options for "more colors" like in word. I've done format, cell, patterns. No luck. I've right-clicked on the cell I wanted to change and selected format cells. Still only gives me the basic palate with no option for more colors. See screen shots he http://www.senseiouch.com/1.jpg http://www.senseiouch.com/2.jpg I can't find where to get those options; maybe I'm crazy but I'm sure they used to be on these screens. How do I get my color options back? Thanks for any help. Ben -- Dave Peterson |
#4
|
|||
|
|||
Thanks a lot, Max and Dave. That got it for me. Maybe the dialogue
box-thing was a figment of my imagination left over from Word. Thanks again. Ben |
#5
|
|||
|
|||
You're welcome !
Glad to hear that .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "bjcouch" wrote in message ... Thanks a lot, Max and Dave. That got it for me. Maybe the dialogue box-thing was a figment of my imagination left over from Word. Thanks again. Ben |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print grayscale font in Excel 2003? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I change fill color default in excel 2003? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |