I have a big long spreadsheet (great description!). Right now i'm using the
AutoFormat option to make every other row (e.g. rows 2, 4, 6, 8, etc...) have
a color shade of light gray.

The complication of this is:
1) Due to length and amount of data in spreadsheet, takes a LONG time to
make the change
2) Have to repeatedly re-AutoFormat as I add more information to the
spreadsheet
3) Because of some special titling at the top of the sheet, I have to
manually select a few rows down from the top, then select the bottom-most row
before AutoFormatting

I'm wondering if somebody could inform me of a way to have Excel
automatically do the gray cell shading on-the-fly as i enter data, or
automatically have every other row starting from a certain cell onwards have
gray shading.

I'm thinking this would use conditional formatting, but i'm horrible at math
and formulas. Since I need the shading to start at a certain row, please let
me know what cell number i should be inputting into your formula.

Thanks!!