Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Count cells in range w/specific background color? | Excel Worksheet Functions | |||
Background color according to a specific cell value | Excel Discussion (Misc queries) | |||
how to count cells with specific format (background color)? | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |