Cell Shading (Patters) - Easier Way to Apply Color to Cell Rows all at Once?

So maybe I've been a novice in this category but this is the problem...

A lot of the worksheets/documents I create in Excel I "fancy" them up by making every other row a specific color for easier reading.

Right now I've been going through and having to select every other row with the mouse and clicking it to select it, selecting properties then going to shading and changing the color to what I want.

Obviously if there are only like 10-20 rows that's not a problem, but what about a couple hundred?

Is there another/automated way of doing this?

Anyone have any ideas on how to do this in Excel 2007.. Stupid GUI hate that there's no option for other things..