You have to change the pallette, Excel has no more than 56 colors to work
with:

If ActiveCell.Interior.ColorIndex 2 Then _
ActiveWorkbook.Colors(ActiveCell.Interior.ColorInd ex) = _
RGB(221, 255, 221)

HTH. Best wishes Harald

"pmguerra" skrev i
melding ...

Hi!

I've used the following code to change the cell color.

Sub dfghrth()

ActiveCell.Interior.Color = RGB(221, 255, 221)

End Sub



But instead of actually changing to the color I've defined, it changes
to a pallette default color...

Help anyone?


--
pmguerra
------------------------------------------------------------------------
pmguerra's Profile:
http://www.excelforum.com/member.php...o&userid=14986
View this thread: http://www.excelforum.com/showthread...hreadid=542600