How to shade every other row

[Amin]

How can I shade every other row on a spreadsheet? I'd
like the entire sheet to be shaded in every other row so
that it is easy to keep track of lines across.

 

[Max]

One way:

Press CTRL + A
(selects entire sheet)

Click Format > Conditional Formatting
Under Condition 1:
Formula Is | =MOD(ROW(),2)
Click Format button > Patterns tab > Light green? > OK
Click OK at the main dialog

 

[Dave R.]

Nice one Max.

I tried to do this with =ISODD(ROW()) but it gave me a message about not
wanting to make references to other workbooks or worksheets. Wonder why it
doesn't work but =MOD(ROW(),2) is acceptable..

 

[Peo Sjoblom]

Because ISODD is part of the ATP and thus an add-in and they reside in
another workbook

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Max]

Thanks for the clarification, Peo !

 

[Dave R.]

Thanks Peo.

I question why they made such a simple function part of a special toolpak,
though I am grateful they included it.

Because ISODD is part of the ATP and thus an add-in and they reside in
another workbook

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Harlan Grove]

I question why they made such a simple function part of a special toolpak,
though I am grateful they included it.

....

It's an unnecessary function. ISODD(x) == (MOD(X,2)=1).