How to modify (or add to) autoformat style?

G

Guest

I'm using Excel 2000 and am not satisfied with the gallery of autoformat
styles. Is it possible to download new ones? Or change an icky green color to
a nice blue? Thanks!
 
E

Earl Kiosterud

Espresso,

I don't know of a way to add custom autoformat schemes, but if it's color,
you could change the colors in the palette in that workbook. Tools -
Options - Color. Click the color in the pallete, Click Modify and change
the color. Now anything that uses that particular color place in the
palette will have the new color. You can do this after the autoformat
formatting has been applied (it's now no different than if you'd manually
formatted the cells). This won't affect other workbooks -- each has its own
palette. You can import this palette into other workbooks too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top