alternate lines

[JB]

Hello
I would like to apply conditional formatting so that every 2 lines has
shading on the next 2 lines.
Example
1 yellow
2 yellow
3 white
4 white
5 yellow
6 yellow and so on
hope that makes sense
Thank you
Jenny

 

[Roger Govier]

Hi

Select the whole range of cells you wish to shade.
Format>>Conditional Formatting>Formula Is> =OR(MOD(ROW(),4)=0,MOD(ROW),4)=3)
Format>Fill colour>Yellow

 

[JB]

Thank you
I've done it but getting a message
'You've entered too few arguments for this function.'
then it says 'click the Insert Function button located to the left of the
equal sign in your formula'.

aaghhh! Don't get what that means.
Jenny
(btw I'm using office 07,)

 

[Pete_UK]

Roger missed an open bracket after the second ROW - the formula should
be:

=OR(MOD(ROW(),4)=0,MOD(ROW(),4)=3)

Hope this helps.

Pete

 

[JB]

YEAYYY!! Thank you so much
Jenny

Roger missed an open bracket after the second ROW - the formula should
be:

=OR(MOD(ROW(),4)=0,MOD(ROW(),4)=3)

Hope this helps.

Pete

 

[Roger Govier]

Thanks, Pete.
Must get some new glasses!!!

 

[Pete_UK]

You're welcome Roger, and Jenny.

Pete