• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

color font red

Hi
I need to add something in the code to make the font red. Thanks.
See code below.

Code:
.CenterHeader = "&""Georgia,Regular""&10& PROJECT MASTER"
 
Last edited by a moderator:
This is what I got so far but it blue K00B0F0 How do I turn this one in to red?


.CenterHeader = "&""Georgia,Regular""K00B0F0&10& PROJECT MASTER"
 
RDEXCEL2020
As You could read below ... and ... after that do some tests with those numbers from 1 to 12.
&K xx. S nnnPrints the characters that follow in the specified color from the current theme.

xx is a two-digit number from 1 to 12 that specifies the theme color to use.

S nnn specifies the shade (tint) of that theme color. Specify S as + to produce a lighter shade; specify S as - to produce a darker shade.

nnn is a three-digit whole number that specifies a percentage from 0 to 100.

If the values that specify the theme color or shade are not within the described limits, Excel will use the nearest valid value.
 
So I added the code &K12S100 but the color is green. I tried from 1-12 and did not see any red color on it.

Please tell me more

Thanks.
 
RDEXCEL2020
If You cannot find the solution Yourself
then You should send a Excel-file here,
which have more than one code line.
= which have sample of Your 'missing red font'.
 
Back
Top