highlighting rows - formula

[Jadegirl]

highlighting rows

Does anyone know a method to highlight every other row or every 4 rows? is there a formula I can use to apply a color formatting every few rows?

Thanks

 

[ISY]

Hallo

Use conditional formatting formula in A4 format:

=SE(INT(RIF.RIGA()/4)-RIF.RIGA()/4<0;0;1)

insert formatting here then copy the cell down.

 

[Smitty]

For every other row you can use this formula in Conditional Formatting:

=MOD(ROW(),2)=1

HTH,

 

[Ingolf]

You can play in conditional formating with formula like this:

=MOD(ROW(),5)<4

or this for alternate row

=MOD(ROW(),2)

 

[Jadegirl]

Thanks... This is awesome!!!!!! YOU ALL ROCK!