View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can create a new default template, with your preferred fill colour:

Create a new, blank workbook.
Choose ToolsOptions
On the Colour tab, click on the yellow square
Click Modify, select a colour as the default, click OK
To make yellow available, select the square that has the same colour
as the new default, and change it to yellow
Click OK.
Choose FileSave As
From the Save As Type dropdown, choose Template (*.xlt)
Name the File "Book.xlt"
Save it in the XLStart folder
(you can search for this -- in Windows XP it may be in
C:\Documents and Settings\UserName\Application Data\Microsoft\Excel)

When you click the New button on the toolbar, the new workbook will be
based on this template.


bowler708 wrote:
How do I change fill color default in excel 2003?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html