Hi
i would do it using conditional formatting - select range
choose format / conditional formatting
choose formula is
enter =MOD(ROW(),3)=0
in the white box
click on format
go to patterns tab
choose colour
ok out of dialog
Cheers
JulieD
"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/