Re: How to shade every third row?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you so much! It works beautifully! ;-)

"Max" wrote:

> > Formula is: =MOD(ROW(),3)=0
>
> On separate sheets, try also tinkering with the other 2 possible settings
> for the formula in condition1, viz., try instead:
>
> =MOD(ROW(),3)=1
> =MOD(ROW(),3)=2
>
> to see the differences that changing the formula makes to the row shading
>
> (Btw, I'm also using Jim's add-in .. )
>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
>
>
.

Relevant Pages