Thread: custom color for font color and or background shading color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
  
Posts: 1,565
Default 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


Reply With QuoteReply With Quote