If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HEADER FONT COLOUR
Hi, is it possible to change the font colour in a
header? If so, how can it be done?? Cheers, Toni |
#2
|
|||
|
|||
HEADER FONT COLOUR
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/davemcritch...el/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 ** "Toni" wrote in message ... Hi, is it possible to change the font colour in a header? If so, how can it be done?? Cheers, Toni |
#3
|
|||
|
|||
HEADER FONT COLOUR
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. |
#4
|
|||
|
|||
HEADER FONT COLOUR
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 he 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. -- DDM "DDM's Microsoft Office Tips and Tricks" Visit us at www.ddmcomputing.com "Toni" wrote in message ... Hi, is it possible to change the font colour in a header? If so, how can it be done?? Cheers, Toni |
#5
|
|||
|
|||
HEADER FONT COLOUR
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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
#6
|
|||
|
|||
HEADER FONT COLOUR
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 ** "David McRitchie" wrote in message ... 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 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
Thread Tools | |
Display Modes | |
|
|