Change Default Font Color

[clintsjones]

How can I change the default font color in Excel? I would like to be able to open a workbook, old or new, and type in Red.

Thanks.

 

[Mark W.]

See the Excel Help Index topic for "Specify formats for a style".

 

[Dougel]

Go to tools/ options/color and pick your shade of red....u would use general to change your default font

 

[lenze]

Mark is correct. You can set a style with any color font. Here is a trick to make a style your default font color. When Excel opens, it creates a workbook called Book1. In Book1 is a NORMAL Style which is the default for all NEW workbooks. Open a new workbook and modify the style NORMAL as you would like it to be. Now, Save the workbook as a template named Book. Place it in your Xlstart folder. Now any NEW workbook will be based on this template and the NORMAL style will be changed.

HTH

Edit: You will have to close and restart Excel for this to take effect
This message was edited by lenze on 2002-06-14 06:47
This message was edited by lenze on 2002-06-14 09:32