Cell bg-color

's Computer Specifications

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.

's Computer Specifications

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

"bobens_83" wrote:

> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing the color of a cell based on the color of another cell.	LATC	Microsoft Excel Misc	6	4th Dec 2009 09:49 PM
HELP W/ VBA: SELECT RANGE, ALLCAPS, CELL COLOR, RETURN TO BLANK CELL/PATTERN CELL	extremejobtvshow@gmail.com	Microsoft Excel Programming	5	28th Jun 2008 07:49 PM
Re: Can't format cell color/text color in Office Excel 2003 in files .	Gord Dibben	Microsoft Excel Misc	4	21st Dec 2007 01:41 PM
cell background color and cell text color	Jeff Klein	Microsoft Excel Worksheet Functions	1	1st Nov 2007 08:59 PM
Can't format cell color/text color in Office Excel 2003 in files .	=?Utf-8?B?Q2hhcmxpZQ==?=	Microsoft Excel Misc	0	16th Sep 2004 04:29 PM