modify a standard color like in 2003

[JeffTNDB]

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

 

[Jim Rech]

It's under Excel Options, Save.

 

[Jon Peltier]

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

 

[Jim Rech]

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.

 

[Jon Peltier]

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

 

[JeffTNDB]

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