Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Custom Colours For Cell Shading (Excel 2003)

    I know I have seen it somewhere but my searches are failing.

    How can I get a wider range of colours to shade cells in my spreadsheet?

    Kerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Colours For Cell Shading (Excel 2003)

    A workbook can use only 56 different colours, but you can customize the colour palette for each workbook individually, in the Color tab of Tools | Options...
    Click a colour in the 56 color palette, then click Modify...
    Note that the last 16 colours in the palette are used as the default fill and line colours for charts.
    You can import the palette from another open workbook by selecting the workbook from the 'Copy colors from' dropdown.

  3. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Custom Colours For Cell Shading (Excel 2003)

    Thanks Hans. Once again - exactly what I was looking for.
    Seeya

Posting Permissions

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