Prev: How do I insert a file into Excel 2007 spreadsheet ?
Next: bahttext
From: Valeria on 21 Apr 2010 04:24
Dear experts,
I have a range which can be autofiltered by users and it's in alternate row
shading (conditional formatting, =mod(row(),2)).

However, when users select their autofilter criteria, the alternate shading
is broken so it is not really usfeul any longer.
Is there a way I can keep it?

Many thanks in advance for your help.
Best regards

--
Valeria
From: Gord Dibben on 21 Apr 2010 10:00
=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP


On Wed, 21 Apr 2010 01:24:01 -0700, Valeria
<Valeria(a)discussions.microsoft.com> wrote:

>Dear experts,
>I have a range which can be autofiltered by users and it's in alternate row
>shading (conditional formatting, =mod(row(),2)).
>
>However, when users select their autofilter criteria, the alternate shading
>is broken so it is not really usfeul any longer.
>Is there a way I can keep it?
>
>Many thanks in advance for your help.
>Best regards

From: Valeria on 21 Apr 2010 11:21
Works very well, thank you very much!
--
Valeria


"Gord Dibben" wrote:

> =MOD(SUBTOTAL(3,$A1:$A$2),2)=0
>
>
> Gord Dibben MS Excel MVP
>
>
> On Wed, 21 Apr 2010 01:24:01 -0700, Valeria
> <Valeria(a)discussions.microsoft.com> wrote:
>
> >Dear experts,
> >I have a range which can be autofiltered by users and it's in alternate row
> >shading (conditional formatting, =mod(row(),2)).
> >
> >However, when users select their autofilter criteria, the alternate shading
> >is broken so it is not really usfeul any longer.
> >Is there a way I can keep it?
> >
> >Many thanks in advance for your help.
> >Best regards
>
> .
>
From: Gord Dibben on 21 Apr 2010 18:51
You're welcome

Thanks for the feedback.

Gord

On Wed, 21 Apr 2010 08:21:01 -0700, Valeria
<Valeria(a)discussions.microsoft.com> wrote:

>Works very well, thank you very much!

 | 
Pages: 1
Prev: How do I insert a file into Excel 2007 spreadsheet ?
Next: bahttext