Results 1 to 4 of 4

Thread: color palet

  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have to share spreadsheets with coleagues from Germany.
    I have a standard UK color pallet. They use a different set of shades.
    How can I extend my color pallet to include their colors aswell?

    Thanks

    Alex

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Excel (at least Excel 97 - 2003) uses a 56 color palette, so you cannot combine ALL colors you use with ALL colors used by your colleagues.

    Customizations to the color palette are stored in the workbook.
    You can import the colors from another open workbook by selecting its name in the "Copy colors from" dropdown in the Color tab of Tools | Options... but this will replace the current palette entirely.

    You should agree on a common color palette with your colleagues.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    milton keynes, Buckinghamshire
    Posts
    252
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I found that when I copied worksheets that were created in the German template into a new workbook, they tried to revert to my UK template, with some very interesting formatting consequences

    Therefore, as a supplementary question, how do I change my standard color template for new workbooks that I create to that of my DE colleagues?

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='pergunas' post='765657' date='16-Mar-2009 18:51'][/quote]
    You could create a blank new workbook and import the German color palette into it. Set everything else the way you want, then save it as an Excel template named Book.xlt (this name is obligatory) in your Excel startup folder (by default, C:\Documents and Settings\<username>\Application Data\Microsoft\Excel\XLStart). This will serve as the default template for creating a new workbook.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •