Better Color Palette for Excel?

ilcaa

Well-known Member
Joined
May 25, 2005
Messages
686
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
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Why not just create your own "Custom Color Palette"?
Tools>Options>Color

lenze
 

ilcaa

Well-known Member
Joined
May 25, 2005
Messages
686
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

Legend
Joined
Feb 18, 2002
Messages
13,690

ADVERTISEMENT

Run this on a blank sheet from a regular module
Code:
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

Well-known Member
Joined
May 25, 2005
Messages
686
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

Legend
Joined
Feb 18, 2002
Messages
13,690

ADVERTISEMENT

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

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,824
Office Version
  1. 2019
Platform
  1. Windows
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

Well-known Member
Joined
May 25, 2005
Messages
686
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,127,387
Messages
5,624,389
Members
416,026
Latest member
melvic69

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top