Help!

Excel 2007: How to change fill color in Theme Colors

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  conditional visibility of check box  
Author Message
David Lipetz
External


Since: Feb 02, 2004
Posts: 40



PostPosted: Tue May 05, 2009 3:14 pm    Post subject: Excel 2007: How to change fill color in Theme Colors
Archived from groups: microsoft>public>excel (more info?)

I have just converted to Excel 2007 from Excel 2003 and am still getting
used to all the changes.

In Excel 2003, one of the standard fill colors was Light Yellow and I have
used it in thousands of spreadsheets. Excel 2007 does not have Light Yellow
in the standard Theme Colors list. I can select it from Custom Colors but do
not want to do that every time or rely on picking it from Recent Colors. In
Excel 2003, you could go to Tools/Options and change the colors that were
presented in the dropdown fill color box. Can this be done in Excel 2007?

Thanks in advance,
David
Back to top
David Lipetz
External


Since: Feb 02, 2004
Posts: 40



PostPosted: Thu May 07, 2009 8:25 pm    Post subject: Re: Excel 2007: How to change fill color in Theme Colors [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Wow. This is the longest any of my posts to this newsgroup have gone
unanswered.

Is there no way to customize the color palette in Excel 2007?


"David Lipetz" wrote in message

>I have just converted to Excel 2007 from Excel 2003 and am still getting
>used to all the changes.
>
> In Excel 2003, one of the standard fill colors was Light Yellow and I have
> used it in thousands of spreadsheets. Excel 2007 does not have Light
> Yellow in the standard Theme Colors list. I can select it from Custom
> Colors but do not want to do that every time or rely on picking it from
> Recent Colors. In Excel 2003, you could go to Tools/Options and change the
> colors that were presented in the dropdown fill color box. Can this be
> done in Excel 2007?
>
> Thanks in advance,
> David
>
Back to top
mstirgwolt
External


Since: Jul 29, 2009
Posts: 1



PostPosted: Wed Jul 29, 2009 1:48 pm    Post subject: Re: Excel 2007: How to change fill color in Theme Colors [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I Agree with David - Why did the standard color palette change in Excel
2007? How can we customize it?
"David Lipetz" wrote:

> Wow. This is the longest any of my posts to this newsgroup have gone
> unanswered.
>
> Is there no way to customize the color palette in Excel 2007?
>
>
> "David Lipetz" wrote in message
>
> >I have just converted to Excel 2007 from Excel 2003 and am still getting
> >used to all the changes.
> >
> > In Excel 2003, one of the standard fill colors was Light Yellow and I have
> > used it in thousands of spreadsheets. Excel 2007 does not have Light
> > Yellow in the standard Theme Colors list. I can select it from Custom
> > Colors but do not want to do that every time or rely on picking it from
> > Recent Colors. In Excel 2003, you could go to Tools/Options and change the
> > colors that were presented in the dropdown fill color box. Can this be
> > done in Excel 2007?
> >
> > Thanks in advance,
> > David
> >
>
>
>
Back to top
jeng02



Joined: Jan 08, 2010
Posts: 1



PostPosted: Fri Jan 08, 2010 8:29 pm    Post subject: [Login to view extended thread Info.]

On the Excel 2007 ribbon, click on the Page Layout menu. In the 'Themes' group on the far left, click on 'Colors.' You can then choose from a built-in list of color groupings, or at the bottom you can "Create New Theme Colors."

You can only specify 8 colors, and Office 2007 will automatically generate the different shades of them.

But I wonder how these colors show up when saving in the older Office 97-2003 format.
Back to top
heverej



Joined: Apr 13, 2010
Posts: 1



PostPosted: Tue Apr 13, 2010 10:02 pm    Post subject: [Login to view extended thread Info.]

Very Happy Fantastic. Jeng02 you are a genius. Well Done!
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum