Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
mycolor = ActiveCell.Offset(0, 1).Interior.Color
ActiveCell.Value = mycolor The above code gives me the integer color values (which I don't understand) for the cell to the right of the active cell and the following code gives me the color palette numbers: mycolor = ActiveCell.Offset(0, 1).Interior.ColorIndex ActiveCell.Value = mycolor How can I get the RGB color values Any info gratefully appreciated Philip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
Find Values in Range Then Color | Excel Discussion (Misc queries) | |||
Sum function when the values in an xls are color coded | Excel Worksheet Functions | |||
Category color changes when changing values. | Charts and Charting in Excel | |||
Neg Values in Chart with Diff Color? | Excel Discussion (Misc queries) |