cells color

[lezawang]

Hi
I want to change cells background color so I did this code in vba expecting the color will be green (code =4) but to my surprise the color turns to Black?!

Cells.Interior.color = 4

Why is that? thank you.

 

[mikerickson]

There are two different ways to color a cell. Actually, there are several.
One way uses the .ColorIndex property, which expects a number between 0 and 65 or xlNone

ActiveCell.Interior.ColorIndex = 4

The .Color property expects an RGB value

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