Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

  • #2
    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, 06:58.
    Regards,

    Wigi

    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

    Comment


    • #3
      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

      Comment


      • #4
        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.

        Comment


        • #5
          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

          Comment


          • #6
            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, 02:52.

            Comment


            • #7
              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
              Regards,

              Wigi

              Excel MVP 2011-2014

              For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

              -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

              Comment


              • #8
                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

                Comment


                • #9
                  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"

                  Comment


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

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

                    Wigi

                    Excel MVP 2011-2014

                    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

                    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

                    Comment


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

                      Hi

                      Update: the posts of Andy Pope in this current thread could be helpful perhaps.
                      Regards,

                      Wigi

                      Excel MVP 2011-2014

                      For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

                      -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

                      Comment


                      • #12


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

                        thank you Wigi!

                        Comment

                        Working...
                        X