Use Conditional Formatting with a formula of

=MOD(ROW(),3=0)

and set the pattern colour to suit

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"LordJezo " wrote in message
...
How would I make a simple macro script that would make every third row a
color of my choosing, as in rows 3, 6, 9, etc.

Is there an easy way to do such a simple task?


---
Message posted from http://www.ExcelForum.com/