How do I create alternating row colors in excel?

[Guest]

I am trying to create alternating row colors. So the first row is a shade of
white and the second row would be a gray color and repeats continuously

 

[MartinW]

Hi Jeff,

Check out this link
http://xldynamic.com/source/xld.CF.html#rows

HTH
Martin

 

[Guest]

One way.

Select the rows you want and then select format - conditional formatting -
formula is and enter the formula

=MOD(ROW(),2)

and then select your non-white colour.

Mike

 

[Guest]

Select the area you wish to have shaded and select: format, conditional
formatting from the menu bar - click the list button to change Cell Value is:
to Formula is: and enter the following:
=MOD(ROW(),2)=0
click the format button and pattern tab to set a background color of gray.
Click okay and even rows should now be gray, while odd rows are still white.
Use:
=MOD(ROW(),2)=1
instead if you wish to reverse that.

 

[Guest]

Well I tried what you guys said it wasnt working. However what I did was in
ms excel 07 underneath conditional formatting on the HOME tab I clicked
format as a table and there was different layouts of colors and that
worked....thanks

 

[Guest]

Well... to use conditional formatting to color your rows, just in case you
get tired of the table stuff... and for anyone else reading this that has '07:
Select your range.
On the Home Tab, in the Styles Section, click Conditional Formatting.
Select New Rule.
Click Use a formula to determine which cells to format.
Enter the formula:
=MOD(ROW(),2)=0
click the Format button and Fill tab to set a background color of your choice.
Click OK and OK and admire your handiwork!