Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm working with VB in Excel 2003, and I need more colors than are
offered on the default palette. Does anyone know if and where I might be able to get a broader range of colors and their codes? Here's what my program looks like: Sub ColorTest() 'Changes cell color based on adjacent to the left cell value j = 2 While j < 7 i = 2 While ActiveSheet.Cells(i, j - 1) < "" ActiveSheet.Cells(i, j).Interior.ColorIndex = Switch( _ ActiveSheet.Cells(i, j - 1) < 0.5, 3, _ ActiveSheet.Cells(i, j - 1) < 1, 9, _ ActiveSheet.Cells(i, j - 1) < 1.5, 6, _ ActiveSheet.Cells(i, j - 1) < 2, 12, _ ActiveSheet.Cells(i, j - 1) < 2.5, 4, _ ActiveSheet.Cells(i, j - 1) < 3, 10, _ ActiveSheet.Cells(i, j - 1) < 3.5, 50, _ ActiveSheet.Cells(i, j - 1) < 4, 8, _ ActiveSheet.Cells(i, j - 1) < 4.5, 5, _ ActiveSheet.Cells(i, j - 1) < 5, 11, _ ActiveSheet.Cells(i, j - 1) < 5.5, 7, _ ActiveSheet.Cells(i, j - 1) < 6, 13, _ ActiveSheet.Cells(i, j - 1) < 6.5, 15, _ ActiveSheet.Cells(i, j - 1) < 7, 16) i = i + 1 Wend j = j + 2 Wend End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Color Palette | Excel Discussion (Misc queries) | |||
Bring up Color Palette to select color | Excel Discussion (Misc queries) | |||
Color Palette, color disappears | Excel Discussion (Misc queries) | |||
VBA color palette | Excel Programming | |||
Changing color in color palette | Setting up and Configuration of Excel |