VBA - formatting header/footer font colour

[ChloeLM]

Hi everyone

I'm formatting a header/footer on my sheet. I've worked out how to change the font, size and whether it's bold. I'm struggling to change the font colour/tint though, it's not clear where the instructions go. I'm also not certain about what the code for this looks like, according to the help guide it's &K xx. S nnn but that gives me alot to go wrong!!

Based on the theme colour elsewhere I've used:

ThemeColor = xlThemeColorLight1 
.TintAndShade = 0

I'm trying to add the code to change the colour to the following three lines:

FirstPage.RightFooter.Text = "&08&""DM Sans""Page &P of &N"
.FirstPage.CenterFooter.Text = "&10&""DM Sans""Confidential"
.FirstPage.LeftFooter.Text = "&""DM Sans""&08" & Range("A2")

Please can anyone help me to understand what the instruction to change the colour looks like, and where it goes?

Any assistance gratefully received!
Thanks
Chloe

 

[KOKOSEK]

With ActiveSheet.PageSetup
    .CenterFooter = "&KFFFF00" & "This is yellow text footer"
    .RightFooter = "&KFF0000" & "&08&""DM Sans""Page &P of &N I AM RED"
    .LeftHeader = "&K00FF00" & "&08&""DM Sans""I AM GREEN HEADER"
End With

Long story short: &K and hex coded colour.

 

[ChloeLM]

With ActiveSheet.PageSetup
    .CenterFooter = "&KFFFF00" & "This is yellow text footer"
    .RightFooter = "&KFF0000" & "&08&""DM Sans""Page &P of &N I AM RED"
    .LeftHeader = "&K00FF00" & "&08&""DM Sans""I AM GREEN HEADER"
End With

Long story short: &K and hex coded colour.

Bingo! Thanks