Select all rows.

FormatConditional FormattingFormula is: =MOD(ROW(),2)=1

Pick a pattern from Format and OK your way out.


Gord Dibben MS Excel MVP


On Sat, 10 Jun 2006 13:36:02 -0700, dramajuana
wrote:

Is there a way to automatically color every other row with a certain color?
Selecting each row individually is starting to make me go nutty.

Gord Dibben MS Excel MVP