formatting background color of a cell with custom colors

[Guest]

Hi,
How can we set the interior color of a cell with custom colors other than
color index values..like say i wan to set "#ccccff" this as background color
of cell.

 

[Leith Ross]

Hello sprasad,

Range("A1").Interior.Color = RGB( &HCC, &HCC, &HFF)

Sincerely,
Leith Ross

 

[Bob Phillips]

That won't work, Excel will map the colour to the nearest colour on the
colour palette.

sprasad,

You will need to define new colours to the colour palette first before you
can use the new colour, such as

ActiveWorkbook.Colors(25) = RGB(&HCC, &HCC, &HFF)


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Hi,
Thanks for the response. I am trying do that in C#,it works in VB but not
in C# as there is no RGB available.I tried to use
System.Drawing.Color.fromArgb() but its giving type mismatch

That won't work, Excel will map the colour to the nearest colour on the
colour palette.

sprasad,

You will need to define new colours to the colour palette first before you
can use the new colour, such as

ActiveWorkbook.Colors(25) = RGB(&HCC, &HCC, &HFF)


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Sorry, I can't help with C#.

--

HTH

RP
(remove nothere from the email address if mailing direct)