alternate lines

  • Thread starter Thread starter JB
  • Start date Start date
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
 
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
 
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,)
 
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
 
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...
 
Back
Top