autoformat add or change
 

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.

autoformat add or change
 

Roll your own using Conditional Formatting

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

FormatConditional FormattingFormula 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
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.