 |
|
|
|
Next: Excel as a Quote Tool/Template
|
| Author |
Message |
External
Since: Feb 12, 2004
Posts: 2
|
(Msg. 1) Posted: Thu Feb 12, 2004 2:55 pm
Post subject: Autoformat Colors
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
|
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 3828
|
(Msg. 2) Posted: Thu Feb 12, 2004 6:00 pm
Post subject: Re: Autoformat Colors [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <f5604a4c.0402121155.260bcf3e.RemoveThis@posting.google.com>,
jessica.RemoveThis@jessicawinograd.com (Jessica) wrote:
> I would like to use List 1 or List 2 Autoformats but don't like the
> default colors for the rows. Is there any way to change these colors?
Choose Preferences/Color, and modify the colors that are used in the
Formats (might take a bit of playing around to get the right one(s)).
XL can display only 56 colors at a time, so if you change the color for
a border, and it is the same color as is used for a font style elsewhere
in the same workbook, the font color will change as well.
This works only for each workbook. If you want to modify the colors for
all new workbooks, create a blank workbook, modify the colors to suit,
and save it *as a template* with the name "Workbook" (no quotes, no
extension) in the Microsoft Office N:Office:Start:Excel folder, where N
= 98, 2001, or X, depending on your version. From then on, new workbooks
created with File/New will use that template to create new books.<!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Feb 12, 2004
Posts: 2
|
(Msg. 3) Posted: Sat Feb 14, 2004 3:28 pm
Post subject: Re: Autoformat Colors [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
JE McGimpsey <jemcgimpsey.DeleteThis@mvps.org> wrote in message news:<jemcgimpsey-E249C0.15000012022004.DeleteThis@msnews.microsoft.com>...
> In article <f5604a4c.0402121155.260bcf3e.DeleteThis@posting.google.com>,
> jessica.DeleteThis@jessicawinograd.com (Jessica) wrote:
>
> > I would like to use List 1 or List 2 Autoformats but don't like the
> > default colors for the rows. Is there any way to change these colors?
>
> Choose Preferences/Color, and modify the colors that are used in the
> Formats (might take a bit of playing around to get the right one(s)).
>
> XL can display only 56 colors at a time, so if you change the color for
> a border, and it is the same color as is used for a font style elsewhere
> in the same workbook, the font color will change as well.
>
> This works only for each workbook. If you want to modify the colors for
> all new workbooks, create a blank workbook, modify the colors to suit,
> and save it *as a template* with the name "Workbook" (no quotes, no
> extension) in the Microsoft Office N:Office:Start:Excel folder, where N
> = 98, 2001, or X, depending on your version. From then on, new workbooks
> created with File/New will use that template to create new books.
Thanks. I did a "reset" on the Colors and List 1 is now single gray
bars and List 2 is alternating double green bars which is most of what
I was looking for.<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Autoformat Colors |
|
| Back to top |
|
| |
| Related Topics: | Number-To-Text Autoformat - I don't know what you would call this, but what I'd like to do is enter in numbers in a list & have the cell generate text based on pre-determined formulas I enter. For example, if I want to make a list with MAN, WOMAN, and CHILD, assigning them the....
autoformat not formating to selected format - Hi, I am trying to use autoformat in excel for mac 2004 and I will select a format like accounting1 - the sample shows but excel doesn't format it correctly. It seems to only format the simple correctly. The others will be missing a vertical line or a..
Modifying Chart colors - When I try and set my chart color preferences, I go to the Colors preference pane, and I see the standard color palette, and below it the chart fill and chart line palettes. I want to modify the fill and line colors using colors from the standard color....
Modifying Chart colors - When I try and set my chart color preferences, I go to the Colors preference pane, and I see the standard color palette, and below it the chart fill and chart line palettes. I want to modify the fill and line colors using colors from the standard color....
Cell colors and gridlines won't print! - I'm updated to 10.5.5 running on OS 10.3.4 (or is it 10.3.5? Had the=20 problem before the latest update, too). When I print a spreadsheet to which I've applied color to the cells, and = to=20 which I've enabled gridline printing, the colors and.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Profile
Private Messages
Log in
