Format color in every other row easy?

[joseph9936]

I have a sheet that I would like to have one row white and the other light grwy so it is easier to read the data in the sheet. any ideas to make it a quick to do?
Thanks

 

[ESFjsmith]

I do the same thing for ease of viewing. I just highlight every other row and change the fill color.

 

[joseph9936]

I have done that before but I have over 500 entries to do. I thought there might be some quicker way.....

 

[shg]

See http://www.mrexcel.com/articles/greenbar-formatting-in-excel.php

 

[Smitty]

Welcome to the Board!

Select your range, then in Conditional Formatting you can use the following formula:

=MOD(ROW(),2)=1

And apply the fill you want.

This method won't care if you add/delete rows and will automatically adjust.

HTH,