Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Borders | Excel Discussion (Misc queries) | |||
Borders | Excel Worksheet Functions | |||
borders | Excel Discussion (Misc queries) | |||
Borders | Excel Discussion (Misc queries) | |||
Borders | Excel Discussion (Misc queries) |