LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Create new border style?

I'm trying to create a style in which the top and bottom of a range have
different color border. The ranges may have different numbers of rows, and I
want the top border of the top cell in the range to be, for example, red, and
I'd like the bottom border of the bottom cell in the range to also be red.
There are other attributes of the cells in the range (shading, number format,
etc.) that I do not want to change when applying the new style.

I can't see how to do this -- I can only see how to create a new style for
cells, not for multiple rows. Specifically, when I create a style w/ top and
bottom borders defined (e.g. red), and apply it to a range, then all
horizontal lines in the range are red. I don't want the internal lines red,
I want to leave them alone, it's just the very top and very bottom lines /
borders.

Suggestions? Thanks very much,
Alex
 
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
Creating a Default Border Style notmaria619 Excel Discussion (Misc queries) 0 September 25th 06 04:06 AM
Excel 2003 List does not preserve border style for all rows Geetha Excel Discussion (Misc queries) 0 August 16th 06 07:22 PM
Change default border style? kyot58 Excel Discussion (Misc queries) 0 February 27th 06 06:00 PM
How do you create a page border in Excel? Tricia Excel Discussion (Misc queries) 4 September 23rd 05 03:34 PM
How to create thin cell border Dale Fox Excel Discussion (Misc queries) 4 December 7th 04 04:37 AM


All times are GMT +1. The time now is 02:25 AM.

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"