#1   Report Post  
Posted to microsoft.public.excel.misc
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"
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Borders DAH Mist Excel Discussion (Misc queries) 0 October 1st 07 10:24 PM
Borders anita Excel Worksheet Functions 6 September 15th 06 01:15 PM
borders Brush Prairie Excel Discussion (Misc queries) 0 August 23rd 05 02:57 AM
Borders linda Excel Discussion (Misc queries) 2 January 28th 05 01:05 PM
Borders linda Excel Discussion (Misc queries) 0 January 25th 05 05:31 PM


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"