Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: to change the color of "font" in (custom header & footer)

  1. #1
    Join Date
    20th February 2006
    Posts
    55

    to change the color of "font" in (custom header & footer)

    hi!
    I use the "custom header&footer", and I want to to change the color of font, but I don't finde this choice!

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,006

    Re: to change the color of "font" in (custom header & footer)

    Bad luck for you Lion, it's not standard.

    Have a look at the site of Allen Wyatt. He also proposes a workaround. Perhaps there could a VBA avenue, but personally I'm not aware of any such.

    Wigi
    Last edited by Wigi; May 11th, 2006 at 06:58.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    16th June 2004
    Location
    Canada Quebec
    Posts
    260

    Re: to change the color of "font" in (custom header & footer)

    Hi Lion

    Your question pick my curiousty. Unfortunatelly there is no way to change the color of the font in a footer/heater

    http://support.microsoft.com/default...b;en-us;Q95478

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    20th February 2006
    Posts
    55

    Re: to change the color of "font" in (custom header & footer)

    hi Wigi,
    hi Jetted,
    really I'm astonished to lose this feature.
    suppose I've "logo" and addresses ,and I want to use this "work book" as official letter!
    however,I'll try to type the addresses , and phone numbers, then I'll insert them as picture in(custom header&footer).
    I Know it's not an ideal method, but I've nothing to do in other facility.
    thank you again.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    16th June 2004
    Location
    Canada Quebec
    Posts
    260

    Re: to change the color of "font" in (custom header & footer)

    Hi Lion

    There is some work around see
    http://www.exceltip.com/st/Adding_a_...ooter/202.html

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    20th February 2006
    Posts
    55

    Re: to change the color of "font" in (custom header & footer)

    thank you jetted
    that's will solve the matter for "logos"
    but if want ,for example, colored addresses ,I need at first an aid to another program like photoshop to make them as picture and to insert it to excel.
    may you have better method program like " photoshop"
    Last edited by lion; May 12th, 2006 at 02:52.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,006

    Re: to change the color of "font" in (custom header & footer)

    Hi Lion

    You can make your addresses in Excel, select them, choose Copy, press Shift, choose Edit, Paste as picture. At least this is possible

    Wigi

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    16th June 2004
    Location
    Canada Quebec
    Posts
    260

    Re: to change the color of "font" in (custom header & footer)

    Hi Lion

    Personnaly I would use MS-Paint it is free and it is only for an address.

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    20th February 2006
    Posts
    55

    Re: to change the color of "font" in (custom header & footer)

    thank you wigi,
    thank you jetted,
    both of your suggestions, were useful.
    also,I think I can overcome this matter which concerning to " header", by using" rose to repeat at top"

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,006

    Re: to change the color of "font" in (custom header & footer)

    For header it is, but this won't work for your footers.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Change Font Color In Print Footer
    By lezaheam in forum EXCEL HELP
    Replies: 3
    Last Post: June 10th, 2008, 01:48
  2. Replies: 10
    Last Post: June 14th, 2006, 04:18
  3. change row color for "total" rows
    By helpplease in forum EXCEL HELP
    Replies: 5
    Last Post: December 1st, 2005, 08:07
  4. Replies: 5
    Last Post: September 17th, 2004, 02:14

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno