Conditional Format for every two rows

[Guest]

Is there a way to format 2 rows, skip to rows, format 2, skip 2 ... using
conditional formatting? I'm familiar with =MOD(ROW(),2)=0...but it does
every other row. I want it to skip two rows, format the next two, skip 2,
format the next two, etc.

Is this possible? Thanks,

Joe

 

[Dave Peterson]

How about:

=MOD(ROW(),4)<2

Depending on where you want the rows shaded, you may want something like:

=MOD(ROW()+1,4)<2

(or some adjustment)

 

[Roger Govier]

Hi

Try
=OR(MOD(ROW(),4)=1,MOD(ROW(),4)=2)

 

[Guest]

This is perfect. Thank you both!

How about:

=MOD(ROW(),4)<2

Depending on where you want the rows shaded, you may want something like:

=MOD(ROW()+1,4)<2

(or some adjustment)