Prev: Adv. Filter - Want to copy to inactive sheet
Next: Making a Excel file Read Only
From: bwilde on 12 Jan 2010 11:01
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.
From: Gord Dibben on 12 Jan 2010 18:07
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
<bwilde(a)discussions.microsoft.com> 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.

 | 
Pages: 1
Prev: Adv. Filter - Want to copy to inactive sheet
Next: Making a Excel file Read Only