Cell colors

  • Thread starter Thread starter PO
  • Start date Start date
P

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
 
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
 
Back
Top