Alternate Color Lines when using Custom Views

G

GLT

Hello Everyone,

I used the following code in the Conditional Fomatting dialog box to acheive
alternate colour lines:

=MOD(ROW(),2)=1

This works fine, except when I choose a custom view, the alternate lines do
not re-color themselves and I get blocks of one color or another - looks
messy...

Does anyone know how to fix this?

Thanks
 
B

Bob Phillips

What is the custom view doing specifically?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

GLT

Hi Bob,

Thanks for your response - I have autofilter switched on for the columns and
I have saved a few different filters as a custom view...

Whenever I select a custom view and the data is filtered, the color lines
are based from the original view...

Cheers
 
B

Bob Phillips

Could it be because although the autofilter is hiding some rows, the MOD
function does not ignore them. Maybe this formula will work better

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

David McRitchie

Sorry Bob, I overlooked your reply, in fact I missed that view
was autofilter so was unsure of my answer then.
 
B

Bob Phillips

No problem David, it never hurts, especially with the problems people
sometimes get with not seeing some posts.

Regards

Bob
 
G

GLT

Thanks Bob that works great :)

Bob Phillips said:
No problem David, it never hurts, especially with the problems people
sometimes get with not seeing some posts.

Regards

Bob
Click to expand...
 
Top