Thread: Shortcut to Greying every other row?

Hello,

I do a spreadsheet every night for work, and I grey every other row for ease of reading.
At first I started to "Ctrl select" every other row by hand, but then I discovered this code:

=AND(MOD(ROW(),2),COUNTA($A1:$D1))

Which is an awesome help!
However, I'm American so I'm looking for a way to further simplify my life.

I have the code saved in a Microsoft Doc and have to manually enter it into conditional formatting each time.

Is there a way I can program this into excel so I don't have to manually enter it?

I attempted to save it into a worksheet and have excel open it as a macro every time it opens, but that failed miserably.

Any thoughts?

Thanks,

-Jesse