Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mr_espresso
 
Posts: n/a
Default How to modify (or add to) autoformat style?

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!
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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.
--
Earl Kiosterud
www.smokeylake.com

"mr_espresso" wrote in message
...
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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i get autoformat name of range in excelsheet? classpeople Excel Worksheet Functions 0 June 22nd 05 03:16 PM
Currency Style button Anita Excel Discussion (Misc queries) 3 April 18th 05 12:48 AM
modify autoformat Ashoke Excel Discussion (Misc queries) 1 January 28th 05 02:55 PM
Modify Date Changes when NOT saving LoriStar Excel Discussion (Misc queries) 1 December 10th 04 12:14 AM
Modify Row & Cell Contents based upon Cells Values bpat1434 Excel Worksheet Functions 1 November 7th 04 03:12 AM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"