How do I change the The predefined Autoformat settings?

[Jon osborn]

In the Autoformat feature of excel 2003 there are a list of predefined
Autoformats. I Like the List 1 but want it green instead of gray. Like the
list 2 but I want every other line to be green. How can I add a predfined
one or create a new one?

 

[Gord Dibben]

Jon

You cannot add to or edit the Autoformats.

You can achieve similar banding with your choice of color through Conditional
Formatting.

See Chip Pearson's site.

http://www.cpearson.com/excel/banding.htm

Gord Dibben Excel MVP

On Wed, 20 Oct 2004 12:17:05 -0700, "Jon osborn" <Jon

 

[Jon Osborn]

THanks that worked great once I figured out there were two N values in the
formula.

Jon