How do I create alternating row colors in excel?
 

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

How do I create alternating row colors in excel?
 

Hi Jeff,

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

HTH
Martin

How do I create alternating row colors in excel?
 

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

"Jeff" wrote:

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

How do I create alternating row colors in excel?
 

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.

"Jeff" wrote:

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

How do I create alternating row colors in excel?
 

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

"MartinW" wrote:

Hi Jeff,

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

HTH
Martin

How do I create alternating row colors in excel?
 

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!


"Jeff" wrote:

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

"MartinW" wrote:

Hi Jeff,

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

HTH
Martin