Cell bg-color

[Guest]

Hi. I'm setting cell background color

Cells(ctr, 4).Interior.Color = RGB(0, 191, 255)

Is there some possibility to write the color definition in different way, eg.
'alice blue' or '#F0F8FF'?

Greetings. P.

 

[Guest]

you can use

Range("A1").Interior.ColorIndex = 3

A full list of the colorindex numbers can be found here

http://www.geocities.com/davemcritchie/excel/colors.htm

Mike