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

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

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

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

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/

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

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/