Draw horizontal line every fifth row on output list?

Too_Much_Coffee ® · Jun 17, 2004

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 ® · Jun 17, 2004

Too_Much_Coffee ® wrote:

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

Peo Sjoblom · Jun 17, 2004

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