Thread: borders
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default borders

I am making a price list in excel. I need to do horizontal parallel
borders every 5 lines and I was wondering if there was a way to
automatically do this as opposed to manually clicking in the borders.


One way is to use conditional formatting.

First select the whole sheet and use:
Format Conditional formatting

In the resulting dialog box, use the pull-down to choose
Formula Is
and in the empty rectangle put
=MOD(ROW(),5)=0

Then click the "Format" button and in the "Border" tab select the bottom
border.

Finally, click "OK"