Results 1 to 5 of 5
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    red text footer (Excel 2000)

    Is it possible to format the text colour in Excel's headers and footers?

    zeddy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: red text footer (Excel 2000)

    AFAIK, this is not possible in XL 2000; I don't know about XP.

    What you *can* do is:
    <UL><LI>Format the top row(s) of your worksheet as you wish (with colors, graphics, whatever)
    <LI>Select File / Page Setup..., Sheet tab
    <LI>Enter the rows you want to print as header in Rows to repeat, e.g. 1:1 or 1:3
    <UL>

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: red text footer (Excel 2000)

    Alas it is the footer I need.

    You can't seem to do it in XP either, although in XP you do have the very nice option of including logos and pictures in your footer - pity you can't change font colour!!

    Thanks for confirming my suspicions. ..unless someone knows of a secret trick
    zeddy

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: red text footer (Excel 2000)

    I found the following in the help file. It looks like you can control some formatting, but color is not one of them:

    Formatting Codes for Headers and Footers
    The following special formatting codes can be included as a part of the header and footer properties (LeftHeader, CenterHeader, RightHeader, LeftFooter, CenterFooter, RightFooter).

    Format code Description
    &L Left aligns the characters that follow.
    &C Centers the characters that follow.
    &R Right aligns the characters that follow.
    &E Turns double-underline printing on or off.
    &X Turns superscript printing on or off.
    &Y Turns subscript printing on or off.
    &B Turns bold printing on or off.
    &I Turns italic printing on or off.
    &U Turns underline printing on or off.
    &S Turns strikethrough printing on or off.
    &D Prints the current date.
    &T Prints the current time.
    &F Prints the name of the document.
    &A Prints the name of the workbook tab.
    &P Prints the page number.
    &P+number Prints the page number plus the specified number.
    &P-number Prints the page number minus the specified number.
    && Prints a single ampersand.
    & "fontname" Prints the characters that follow in the specified font. Be sure to include the double quotation marks.
    &nn Prints the characters that follow in the specified font size. Use a two-digit number to specify a size in points.
    &N Prints the total number of pages in the document.
    Legare Coleman

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: red text footer (Excel 2000)

    Spot on Legare!
    These remind me of the Lotus 123 methods - maybe its a compatibilty thing.
    I shall check my old Lotus memory and see if there was a code for colour.
    The codes you gave can be really useful , e.g. can start page numbering from any page number

    Many thanks

    zeddy

Posting Permissions

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