change default fill color

[Shawn]

I have been searching the net and the KB but can not find answer or
solution to this problem. I want my excel cell auto fill color to default
to light grey instead of yellow. Is this possible? And if so, how do I do
it?

Thanks for any help you can provide.

Shawn

 

[Debra Dalgleish]

You can create a new default template, with grey as the default fill
colour:

Create a new, blank workbook.
Choose Tools>Options
On the Colour tab, click on the yellow square
Click Modify, select light grey that you want to use as the default,
click OK
To make yellow available, select the light grey square, and change it to
yellow, click OK.
Choose File>Save 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 start Excel, or click the New button on the toolbar, the new
workbook will be based on this template.