On Fri, 18 Apr 2008 09:24:01 -0700, WBTKbeezy
wrote:

Hello:

I am trying to highlight a table in a certain way. I need 3 rows to be
colored then next 3 white, the next 3 colored, the next three white, etc...
I have checked out http://xldynamic.com/source/xld.CF.html , but I couldn't
quite modify what it was doing for what I need, I don't want every other
highlighted, but I need 3 on 3 off... Can someone provide assistance?

Thanks.


Try this:

=MOD(ROW()-1+n,m+n)=MOD(n,m+n)

this is TRUE for the m first rows and then FALSE for the next n rows
and so on.

For your case use m=3 and n=3. Change the -1 if your table doesn't
start at row number 1.

Hope this helps. / Lars-Åke