Daren

Pete's formula won't survive through filtering if you intend to do any.

This will keep alternate row colors even when filtering.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP


On Mon, 29 Sep 2008 06:06:00 -0700, Daren
wrote:

Thanks!

"Pete_UK" wrote:

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.