row formatting

Posted by Mike on December 18, 2001 8:31 AM

I'd like a macro that will format the interior color of a range of cells in every 5th row of a work sheet
Range= f16:j16
next range =f21:j21

Posted by bob umlas on December 18, 2001 9:04 AM

You don't need a macro. Select F16:J65536 (or wherever you want this to end). Then use Format/Conditional Formatting, Change "Cell Value Is" to "Formula Is", then enter
=mod(row(),5)=1
then click the Format button, the Patterns tab, and pick a color.