alternate lines

J

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
 
R

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
 
J

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,)
 
P

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
 
J

JB

YEAYYY!! Thank you so much
Jenny

Pete_UK said:
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
Click to expand...
 
Top