About Us

Ben[_14_]

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

JLGWhiz[_2_]

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" wrote in message
...
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

Ben[_14_]

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

wrote in message
...
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	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checkbox to change background color, font color and remove/ add bo	Sara	Excel Discussion (Misc queries)	2	May 1st 23 11:43 AM
how can I conditionally change font color, or background color?	MOHA	Excel Worksheet Functions	3	August 21st 06 06:57 PM
Cell background color (interior color) setting not working	Martin E.	Excel Programming	1	May 21st 06 07:00 PM
Default Border, Font Color, and Cell Background Color	Elijah	Excel Discussion (Misc queries)	1	October 28th 05 04:10 PM
Excel 2003 Font Color and Background Color	DrankPA6	Excel Discussion (Misc queries)	1	August 12th 05 11:43 PM

Menu

About Us