Conditional Borders?
 

Is there a way to set up a conditional border? For example, I have a 20 page
sheet prtinting and would like to have a border print every 10th line or
every 5th line. Sometimes whenI insert or move things around I need to re-do
the borders and it is time consuming. I'm hoping there might be a quicker,
automated method of doing the work.
Thanks in advance!
John

Conditional Borders?
 

Format/ Conditional Formatting/ Formula is:
=MOD(ROW(),5)=0
Set a border at the bottom of the cell.
--
David Biddulph

"MarcoPolo" wrote in message
...
Is there a way to set up a conditional border? For example, I have a 20
page
sheet prtinting and would like to have a border print every 10th line or
every 5th line. Sometimes whenI insert or move things around I need to
re-do
the borders and it is time consuming. I'm hoping there might be a quicker,
automated method of doing the work.
Thanks in advance!
John