modify a standard color like in 2003
 

In Excel 2003, you could modify an existing standard color, by clicking
tools, options, color, and then mofifying one of the basic colors to a unique
one. Is this possible in Excel 2007? It is a very useful tool when you want
to change everything in a workbook that is red to say green without having to
each cell or object individually. Thank you

modify a standard color like in 2003
 

It's under Excel Options, Save.

--
Jim
"JeffTNDB" wrote in message
...
In Excel 2003, you could modify an existing standard color, by clicking
tools, options, color, and then mofifying one of the basic colors to a
unique
one. Is this possible in Excel 2007? It is a very useful tool when you
want
to change everything in a workbook that is red to say green without having
to
each cell or object individually. Thank you

modify a standard color like in 2003
 

Isn't that for saving a workbook in 2003 format?

As far as I can tell, you can't change a standard color. I'm not sure, but I
think you can generate a custom theme, though, where most of the colors are
the same and you've adjusted one of the colors. Note that you would only
have control over the base color, and Excel would provide the lighter and
darker variations.

There are a couple blog posts by Tony Jollans discussing colors in Office
2007:
http://proofficedev.com/blog/2007/08/
http://proofficedev.com/blog/2007/10/10/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
It's under Excel Options, Save.

--
Jim
"JeffTNDB" wrote in message
...
In Excel 2003, you could modify an existing standard color, by clicking
tools, options, color, and then mofifying one of the basic colors to a
unique
one. Is this possible in Excel 2007? It is a very useful tool when you
want
to change everything in a workbook that is red to say green without
having to
each cell or object individually. Thank you

modify a standard color like in 2003
 

As far as I can tell, you can't change a standard color

I must admit I just found the equivalent dialog and stopped at that. I
didn't test whether it actually did anything useful. From the length of the
blog entries you cited it looks like I'm a long way from understanding this
area.

--
Jim
"Jon Peltier" wrote in message
...
Isn't that for saving a workbook in 2003 format?

As far as I can tell, you can't change a standard color. I'm not sure, but
I think you can generate a custom theme, though, where most of the colors
are the same and you've adjusted one of the colors. Note that you would
only have control over the base color, and Excel would provide the lighter
and darker variations.

There are a couple blog posts by Tony Jollans discussing colors in Office
2007:
http://proofficedev.com/blog/2007/08/
http://proofficedev.com/blog/2007/10/10/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
It's under Excel Options, Save.

--
Jim
"JeffTNDB" wrote in message
...
In Excel 2003, you could modify an existing standard color, by clicking
tools, options, color, and then mofifying one of the basic colors to a
unique
one. Is this possible in Excel 2007? It is a very useful tool when you
want
to change everything in a workbook that is red to say green without
having to
each cell or object individually. Thank you

modify a standard color like in 2003
 

I know I'm miles from a workable understanding. I've absorbed much of what
Tony wrote, but it's only starting to sink in. I have a pretty nice little
color picker for Excel 2003 that pops up the active workbook's palette and
lets the user select a color. I wanted to build the equivalent for the new
color system, and all I've learned so far is that it will take many nights
and weekends. So my replacement chart UI for 2007 is on hold.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
As far as I can tell, you can't change a standard color

I must admit I just found the equivalent dialog and stopped at that. I
didn't test whether it actually did anything useful. From the length of
the blog entries you cited it looks like I'm a long way from understanding
this area.

--
Jim
"Jon Peltier" wrote in message
...
Isn't that for saving a workbook in 2003 format?

As far as I can tell, you can't change a standard color. I'm not sure,
but I think you can generate a custom theme, though, where most of the
colors are the same and you've adjusted one of the colors. Note that you
would only have control over the base color, and Excel would provide the
lighter and darker variations.

There are a couple blog posts by Tony Jollans discussing colors in Office
2007:
http://proofficedev.com/blog/2007/08/
http://proofficedev.com/blog/2007/10/10/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
It's under Excel Options, Save.

--
Jim
"JeffTNDB" wrote in message
...
In Excel 2003, you could modify an existing standard color, by clicking
tools, options, color, and then mofifying one of the basic colors to a
unique
one. Is this possible in Excel 2007? It is a very useful tool when you
want
to change everything in a workbook that is red to say green without
having to
each cell or object individually. Thank you

modify a standard color like in 2003
 

Jon,
Thank you for your efforts. I would love to get this issue resolved, as I
have an intricate excel workbook that I use as a template, and then simply
change the entire color scheme with a few clicks, when I was using 2003.
Thanks.

Jeff

"Jon Peltier" wrote:

I know I'm miles from a workable understanding. I've absorbed much of what
Tony wrote, but it's only starting to sink in. I have a pretty nice little
color picker for Excel 2003 that pops up the active workbook's palette and
lets the user select a color. I wanted to build the equivalent for the new
color system, and all I've learned so far is that it will take many nights
and weekends. So my replacement chart UI for 2007 is on hold.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com