Draw horizontal line every fifth row on output list?

[Too_Much_Coffee ®]

I want to draw a line at every 5th line, e.g., 7, 12, 17, 22,
etc.
In the attached image I did it manually but there has to be
a better way.

http://tinyurl.com/3fxz3




Too_Much_Coffee ®

 

[Too_Much_Coffee ®]

Too_Much_Coffee ® wrote:


BTW: The line goes across all the cells for that row.

 

[Peo Sjoblom]

Format > conditional formatting, formula is

=MOD(ROW(),5)=2

(adapt to fit, the above will be applied in row 2, 7, 12 and so on)

click format button and put a one line border at the bottom

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom