Cell colors

[PO]

Excel 2003, sp2

Hi,

I want to use a very light grey color in some of the cells in a worksheet.
RGB(234, 234, 234) should produce the color I want, but:

Activecell.Interior.Color = RGB(234, 234, 234) results in a white color
(Colorindex = 2).

Can Excel only handle the 56 predefined colors returned by the ColorIndex
function?

Regards
Pete

 

[Dave Peterson]

Yep.

But you could replace one of those 56 colors with the shade you want.

Tools|options|color tab|modify

This color scheme will travel with the workbook--it's not an application
setting. If you have multiple workbooks that need this, you'll have to do it
for each workbook.

David McRitchie has lots more info here:
http://mvps.org/dmcritchie/excel/colors.htm