autoformat add or change

[bwilde]

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.

 

[Gord Dibben]

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