Results 1 to 5 of 5
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    ColorIndex Colour Palette (Excel 2000)

    Any suggestions about resources for the colour index palette? As far as I can tell, the numbers representing the colorindex property have been assigned randomly.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: ColorIndex Colour Palette (Excel 2000)

    MSKB article XL: Sample Visual Basic Code to Create Color Index Table contains a macro that creates a color table in a workbook.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: ColorIndex Colour Palette (Excel 2000)

    I like mine better:

    Dim IntColorIndex As Integer

    IntColorIndex = 1
    For Each xcell In Selection
    xcell.Interior.ColorIndex = IntColorIndex
    xcell.Value = IntColorIndex
    IntColorIndex = IntColorIndex + 1
    Next xcell

    Select 56 cells and away you go!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: ColorIndex Colour Palette (Excel 2000)

    Extra info: ColorIndex 17 ... 24 are the default fill colors for charts, and ColorIndex 25 ... 32 are the default line colors for charts.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: ColorIndex Colour Palette (Excel 2000)

    That's interesting - I wondered why they were separated from the rest. <img src=/S/salute.gif border=0 alt=salute width=15 height=20>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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