How to color every other row in excel

[API]

How can I color every row with, say, green, to allow users of my report to
read each line more easily as they cursor from left to right? Thanks.

 

[API]

I mean coloring every row of a 200-row excel report using a formula. Thanks.

 

[JE McGimpsey]

I mean coloring every row of a 200-row excel report using a formula. Thanks.

You can't use a formula directly, as formulae can't change cell colors.

You can use a formula in Conditional formatting. For instance, select
your report area and choose Format/Conditional Formatting:

Condition1: Formula is =MOD(ROW(),2)=0
Format1: <pattern>/<green>

for even rows or

Condition1: Formula is =MOD(ROW(),2)=1
Format1: <pattern>/<green>

for odd ones.


For more complex banding see

http://cpearson.com/excel/banding.htm

 

[API]

Thanks, JE!
--
API

You can't use a formula directly, as formulae can't change cell colors.

You can use a formula in Conditional formatting. For instance, select
your report area and choose Format/Conditional Formatting:

Condition1: Formula is =MOD(ROW(),2)=0
Format1: <pattern>/<green>

for even rows or

Condition1: Formula is =MOD(ROW(),2)=1
Format1: <pattern>/<green>

for odd ones.


For more complex banding see

http://cpearson.com/excel/banding.htm