View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
sprasad sprasad is offline
external usenet poster
 
Posts: 2
Default formatting background color of a cell with custom colors

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

"Bob Phillips" wrote:

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)


"Leith Ross" wrote
in message ...

Hello sprasad,

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

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:

http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=484771