custom color for font color and or background shading color
 

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

custom color for font color and or background shading color
 

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

custom color for font color and or background shading color
 

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