Can you add a new auto format and/or change one. There is an autoformat
list1 that hilites every other row in light grey is there a way to make it a
different color?
list 2 is green, but it hilites every two rows.

Roll your own using Conditional Formatting

Select a bunch of rows.....not cells, rows.

Format>Conditional Formatting>Formula is:

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0

Format to your choice of color and hit OK


Gord Dibben MS Excel MVP

On Tue, 12 Jan 2010 08:01:01 -0800, bwilde
<(E-Mail Removed)> wrote:

>Can you add a new auto format and/or change one. There is an autoformat
>list1 that hilites every other row in light grey is there a way to make it a
>different color?
> list 2 is green, but it hilites every two rows.