Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    O2010 - Color themes vs. old color palettes

    Hi,

    Just converted from O2003 to O2010.

    In Excel I have a lot of different color palettes swapping color, using all 56 color options. (40+8+8). In 2010 the idea behind the themes seems to be a good one, but the number of color variations are a lot less with only 6 accent colors available. Anyone having experience how to go about this? (six is far too little for what I need)

    Looking at the xml file doesn't give me an answer either...

    Can the 6 be expanded??
    <a:accent5><a:srgbClr val="92CDDC" /></a:accent5>
    <a:accent6><a:srgbClr val="E36C09" /></a:accent6>
    ....>
    <
    a:accentN><a:srgbClr val="E37D12" /></a:accentN>

    How is "color" with many colors suppossed to be controlled these days??





    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The number of colours is to all intents and purposes unlimited, so I'm not sure what your question really is. The accents are merely gradations of the standard theme colours.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    "...so I'm not sure what your question really is".
    Probably because I took it slightly out of context to simplify (Maybe I should have posted in VBA forum)

    Actually I'm trying to setup themes 1, 2 and 3 that all has varied colors with a lot of gradients.

    In my old VBA code I did this with a toolbar, where the user selected a "color pack" that was then applied to the entire color palette. All done by means of a "For... loop", that ran through the .Colors property of the ActiveWorkbook (below).


    dim iColors as Integer
    For iColors = 1 To 56
    With ActiveWorkbook
    Select Case iColors
    Case 1
    'BLACK
    .Colors(iColors) = RGB(0, 0, 0)
    Case 17, 25, 53
    .Colors(iColors) = RGB(0, 65, 120)
    Case 22, 30, 52
    .Colors(iColors) = RGB(155, 140, 100)
    .....


    In O2010 it seems to me that the .Colors property is no longer working in a meaningful way as the color palette has been changed significantly. So my question is:

    How do I implement code that does what my old "For loop" did - and what should it look like??

    I've tried to record a macro, by creating a theme. But it does not reveal:

    1. how the colors are set
    2. how I get more than 6 accents

    Hope this is more clear
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You don't really. In 2010 (and 2007), the purpose of themes is to make documents look coherent by minimising the use of too many colours. If you want to apply huge numbers of colours, you have to do so manually, rather than as part of a theme; you can also use Cell Styles.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    So the .Colors thought is gone and you just apply specific colors at specific instances??

    So it's not really possible to supply a user with a detailed set of "approved" colors without:

    1. changing the theme?
    2. having only 6 colors available? (urghs!)
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    10 colours, strictly speaking, and 6 grades of each. Any more than that isn't really a theme, IMO, it's a kaleidoscope. (but then, the first thing I do to spreadsheets I receive is remove all the colours so that I keep my retinas intact)
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    So if I understand your comment and the documentation correctly, I can set up a theme with a set of basic colors and vary those with ao. the .tintandshade property of the .interior object?

    Additionally I can also vary any color directly regardless of the theme with the same .tintandshade property of the .interior object?

    Hope this makes sense...
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you want to colour a cell with a specific colour, you can just set the RGB value of the Interior.Color for example.
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for sharing the insights Rory.

    Trying to understand my options in O2010 from both the programmatic and the GUI side.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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