conditional formatting with color- five rows at a time?

  • Thread starter Thread starter bubba
  • Start date Start date
B

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
 
Back
Top