Use Conditional Formatting, with a Formula like:

=MOD(ROW(),2)=1

then set the background colour (Patterns tab) to grey.

Hope this helps.

Pete

On Sep 29, 1:18*pm, Daren wrote:
Hello,

Is there a macro or quick way to highlight alternating rows in color? *For
example, row 1 would be gray, row 3 would be gray, row 5 would be gray, etc.

Thanks.