You can use conditional formatting to do this. Highlight all the data,
then Format | Conditional Formatting and select Formula Is rather than
Cell Value Is in the pop-up. Enter this formula:

=MOD(ROW(),2)=0

then click on the Format button, then the Patterns tab (for background
colour) and choose the colour you want. Click OK twice to exit.

You should find all your cells in even rows are now coloured. If you
want the odd rows coloured then you should change the 0 to 1 in the
formula.

Hope this helps.

Pete

On Nov 5, 4:56 pm, Devin wrote:
Is there a faster way to color format excel spreadsheets? I've got a
spreadsheet containing 2500 cells that must be formatted (highlighting every
odd number) and It's extremely tedious and time consuming to take every cell
and highlight it individually. Is there a faster way to do this?