conditional formatting with color- five rows at a time?

[bubba]

I am applying a cell color every other row in a spreadsheet by doing the
following:

I select the range that I want to format
I then choose Format, Conditional Formatting
In the Conditional Formatting dialog box, I select 'Formula Is' from the
drop-down list, and enter this formula:

=MOD(ROW(),2)=0

I click the Format button, select the Patterns tab, and specify a color
for the shaded rows.

HOWEVER,

I would like to color five consecutive or contiguous rows, and alternate
then with five uncolored rows.

also,

I would also like to color two rows, skip five rows, then repeat, in
another spreadsheet (for weekdays vs. weekends)

Data is already present in all cells.

How do I do that?

TIA

 

[Gord Dibben]

See Chip Pearson's site on "color banding" using CF

http://www.cpearson.com/excel/banding.aspx


Gord Dibben MS Excel MVP