custom color for font color and or background shading color

's Computer Specifications

Hi all -

Is there a way to change font color and background shading color through
code using RGB? I know in word it can be done through the Fonts/ Border
and Shading option.

Can you share some thoughts?

Thanks in advance,

Ben

's Computer Specifications

Range("A3").Font.Color = RGB(250, 125, 125)
Range("A3").Interior.Color = RGB(150, 250, 100)

See also: http://www.mvps.org/dmcritchie/excel/colors.htm

"Ben" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi all -
>
> Is there a way to change font color and background shading color through
> code using RGB? I know in word it can be done through the Fonts/ Border
> and Shading option.
>
> Can you share some thoughts?
>
> Thanks in advance,
>
> Ben

's Computer Specifications

Hi JLGWhiz,

Thanks for your suggestion. It worked very nicely.

Thanks,

Ben

On 5/4/2010 2:27 PM, JLGWhiz wrote:
> Range("A3").Font.Color = RGB(250, 125, 125)
> Range("A3").Interior.Color = RGB(150, 250, 100)
>
> See also: http://www.mvps.org/dmcritchie/excel/colors.htm
>
>
> "Ben"<(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Hi all -
>>
>> Is there a way to change font color and background shading color through
>> code using RGB? I know in word it can be done through the Fonts/ Border
>> and Shading option.
>>
>> Can you share some thoughts?
>>
>> Thanks in advance,
>>
>> Ben
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checkbox to change background color, font color and remove/ add bo	Sara	Microsoft Excel Misc	1	11th Nov 2008 08:17 PM
How do I change the background color and font color in word docum	MarieInLaguna	Microsoft Word Document Management	1	13th Aug 2008 05:02 PM
how can I conditionally change font color, or background color?	=?Utf-8?B?TU9IQQ==?=	Microsoft Excel Worksheet Functions	6	21st Aug 2006 06:57 PM
how can I conditionally change font color, or background color?	=?Utf-8?B?TU9IQQ==?=	Microsoft Excel Worksheet Functions	0	21st Aug 2006 06:43 PM
Default Border, Font Color, and Cell Background Color	Elijah	Microsoft Excel Misc	1	28th Oct 2005 04:10 PM