Results 1 to 3 of 3
  1. #1

    Excel's Automatic color setting (Office 97)

    In my work (financial publications) our standard colour is a very dark blue. We have changed the color pallete to suit our needs. However, for any adhoc text, borders, areas etc, we cannot change the "Automatic" setting from Black to Blue. Anyone know the secret to this one?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Excel's Automatic color setting (Office 97)

    Right click on your desktop and select Properties from the pop up menu. In the properties window, click on the Apparence tab. In the Item combo box select Window. Then next to the Font you should be able to change the font color.
    Legare Coleman

  3. #3

    Re: Excel's Automatic color setting (Office 97)

    Unbelievable! For a long time I have been hitting blank walls in this quest! Then last night, way after midnight, I stumbled on the answer myself. Then this morning I find your answer on the board!! Fateful.

    Many thanks Legare. I discovered that this font variable also determines Auto color for borders and shadings in Word/Excel. I also found where these settings are kept in the Registry and have exported them for use in colleagues' PCs. All in all, a fruitfal call to Woody's mates!

Posting Permissions

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