HEADER FONT COLOUR

[Toni]

Hi, is it possible to change the font colour in a
header? If so, how can it be done?? Cheers, Toni

 

[Paul B]

Toni, I don't think that you can change the font color in the header, but
you can use the first row as the header, have a look here for more details
http://www.geocities.com/davemcritchie/excel/logoshd.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[McNiwram]

Yes, but you will have to do it with a VB code like this one:

Rows(1).Font.ColorIndex=5

I don't know the color index codes but the other might be
of extra help on this one.

 

[DDM]

Toni, for whatever it may be worth, if you search the topic "Change the font
in header and footer text" in Excel 2003, it says "You cannot change the
color of header and footer text."

On his Website, Chip Pearson has some VBA code for headers and footers. It's
here: http://www.cpearson.com/excel/headfoot.htm.. Note that while his code
covers changing fonts, font attributes, and font sizes, he makes no
mention -- and this is significant, I think --of changing font colors.

So I suppose the long and the short of it is that it can't be done. That
being so, I think Paul B's suggestion is the way to go.

 

[David McRitchie]

Hi Paul,
Like Henry Ford -- any color you want as long as it is black.
My website has moved (at least what gets updated) so the
page actually is
Logos and Graphics into headers/footers
http://www.mvps.org/dmcritchie/excel/logoshd.htm

 

[Paul B]

David, thanks for the updated link


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **