Better Color Palette for Excel?

[ilcaa]

I do a lot of real-time analysis thru a real-time data feed, and do a lot of conditional formatting in 4 basic colors.... I am trying to find a download that enhances the color palette so I am get different "shades" of the basic color currently available...

has anyone found anything? thanks

 

[xenou]

I have done this a few times by downloading templates from office online and stealing the custom colors...

Just look for Excel templates and starting picking out some with colors you like.

http://office.microsoft.com/en-us/templates/FX100595491033.aspx?pid=CL100632981033

AB

 

[lenze]

Why not just create your own "Custom Color Palette"?
Tools>Options>Color

lenze

 

[ilcaa]

thanks for the options...i was thinking to use it within a macro and use the colors code number to execute the conditional formatting...looks to me the color property index is standard for macros...where would I find the reference numbers to the different shades of the basic colors used when calling on the color property for formatting??

 

[lenze]

Run this on a blank sheet from a regular module

Sub ShowColorIndex()
   Dim cl As Range
    Dim x As Integer
    x = 0
    Range("$A$3:$A$17").Select
    With Selection
     .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .ColumnWidth = 17.5
        .RowHeight = 20
        .Font.Bold = True
    End With
    For Each cl In Selection
    cl.Value = x
    cl.Interior.ColorIndex = x
    x = x + 1
    Next cl
    
    Range("$C$4:$C$17").Select
    With Selection
     .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .ColumnWidth = 17.5
        .Font.Bold = True
    End With
    For Each cl In Selection
    cl.Value = x
    cl.Interior.ColorIndex = x
    x = x + 1
    Next cl
    
    Range("$E$4:$E$17").Select
    With Selection
     .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .ColumnWidth = 17.5
        .Font.Bold = True
    End With
    For Each cl In Selection
    cl.Value = x
    cl.Interior.ColorIndex = x
    x = x + 1
    Next cl
    
    Range("$G$4:$G$17").Select
    With Selection
     .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .ColumnWidth = 17.5
        .Font.Bold = True
    End With
    For Each cl In Selection
    cl.Value = x
    cl.Interior.ColorIndex = x
    x = x + 1
    Next cl
    
    Range("$D$1").Select
    Selection = "COLORINDEX"
    Selection.Font.Bold = True
    Selection.HorizontalAlignment = xlCenter
    Selection.ColumnWidth = 17.5
End Sub

lenze

 

[ilcaa]

Lenze, thank you for the macro (hope you didnt write that just for me)

(and I know I am a pain in the you know what) BUT since my sheet is for stock related information, i wanted different shades of reds that get more intense as the columns values become more and more negative(from my indicators) and different shades of green based on how it is progressing, so currently it shows RED while the values are actually getting better then it will jump to a grey(neutral) or Green(bullish) thats why i was looking for I guess a customizable palette with different shades of the same color BUT with the color index numbers I can use within a CASE Macro..doesnt seem to be available, i did numerous searches on the 'net...

thank you for always offering some help!

 

[lenze]

The ColorIndex numbers are based on the CURRENT COLOR Palette in your Excel program. If you change the palette, and rerun the ShowColorIndex macro, you will get the ColoIndces for the custom palette.
Hint: Save the file with the custom palette as a template for future use. You can also use RGB values or hexadecimal color values instead of the ColorIndex

lenze

 

[xenou]

I think if you modify the color pallete you can use your "new" colors as if they were the old. Let's, say for example, you turn the "light grey" to a "medium red". You can set your conditional format so that if the condition is met the cell color is medium red just as you would have done for light grey before you modified that color.

Does that make sense? This is how you would use custom colors for a conditional format - the trick is to redefine some colors that you won't need otherwise with the new colors you'd like to use instead.

Regards.

 

[ilcaa]

very cool!!! thank you, I can use your macro to match the color correctly with the number!

Thanks a million to continue making sure I understood!