True, Peo...thanks

Sometimes I lose track of which functions are in the ATP and which aren't.
(Wouldn't it be nice if the formula bar flagged add-in functions and UDFs
with a symbol or a color or...anything, really?)

***********
Regards,
Ron

XL2002, WinXP-Pro


"Peo Sjoblom" wrote:

> It won't work since ISEVEN is part of the ATP and is seen as another
> workbook by conditional formatting, this adaptation maybe
>
> =MOD(CEILING(ROW()/3,1),2)=0
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
>
> "Ron Coderre" <ronSKIPTHIScoderre@bigfoot.com> wrote in message
> news:84918F19-FAAF-46BF-9621-817EE46E30DF@microsoft.com...
> > OK...Now that you know the process...try something like this in the
> > condition
> > statement:
> >
> > Formula is: =ISEVEN(CEILING(ROW()/3,1))
> > That will band alternating groups of 3.
> >
> > Play with it until it does what you want.
> >
> > Per usual, post back with questions.
> >
> > Does that help?
> >
> > ***********
> > Regards,
> > Ron
> >
> > XL2002, WinXP-Pro
> >
> >
> > "tamiluchi" wrote:
> >
> >> Thanks, that's a great site.
> >> What I want to do is shade 3 rows, skip 3 rows. It doesn't show me how to
> >> do
> >> that. Or maybe I just missed it.
> >> I will save the site though. It seems to offer a lot of help.
> >>
> >> "Ron Coderre" wrote:
> >>
> >> > Here's a good place to start:
> >> >
> >> > http://www.xldynamic.com/source/xld.CF.html#rows
> >> >
> >> > Post back with any questions.
> >> >
> >> > ***********
> >> > Regards,
> >> > Ron
> >> >
> >> > XL2002, WinXP-Pro
> >> >
> >> >
> >> > "tamiluchi" wrote:
> >> >
> >> > > Hi
> >> > > I'd like to use alternate shading for 3-row sections. How do I do
> >> > > this?
>
>
>