How would I get every third row to be a specific background color?

[LordJezo]

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

Is there an easy way to do such a simple task

 

[Bob Phillips]

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)

 

[JulieD]

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