Zebra stripe format filtered case as well

[CousinExcel]

Hi,

I learned in "msexcelraj website (could not see a name to mention here to
thank)" how to make zebra stripe formating:
Conditional formating, mod(row(),2)=0).
My additional question is "how can I have zebra appearence when I make
filtering as well ?" When I filter, naturally zebra appearence is losing with
the way above.

Thanks and regards,

Cousin Excel

 

[Mike H]

Hi,

Select the range then format|Conditional format-Formula is

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

ADD

Formula is

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

Pick another colour

OK
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[CousinExcel]

Hi Master Mike,

I could not find where I could making mistake.

I' m doing
- conditional formating
- use a formula to determine which cells to..
- write your formulas
=MOD(SUBTOTAL(3;$A$1:$A$5);2)=0
format ...
- new rule
=MOD(SUBTOTAL(3;$A$1:$A$5);2)=1
format
but all cells are color 2 (mod..= 1 color.)

Thanks and regards,

Cousin Excel

 

[Gord Dibben]

Mike typed an extra $ sign in his formula.

Try this after selecting a great whack of rows.

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

You will get your color band alternating with default color.


Gord Dibben MS Excel MVP

 

[CousinExcel]

Thank you very much.
It helped a lot.
(In fact I had tried the same logic but I must have made a mistake and it
did not work).
Thanks and regards,
Cousin Excel