LOL - Didn't mean that Bob, as like the text says it stripes every 3rd row
or 4th row, but that gives you say 3 white, 1 colour, 3 white, 1 colour etc.
I'm talking about 3 white, 3 colour, 3 white, 3 colour etc.

If you want to create alternate green bars made up of say 3 rows (or any
other color), you can
also use:

For every three rows:
=MOD(ROW()-1,6)<3

For every four rows:
=MOD(ROW()-1,8)<4

For other number of shadings, just make the 2nd number (6 or 8 in example)
twice as much as the
3rd number (3 or 4 in example)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

<snip