Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a Default Border Style | Excel Discussion (Misc queries) | |||
Excel 2003 List does not preserve border style for all rows | Excel Discussion (Misc queries) | |||
Change default border style? | Excel Discussion (Misc queries) | |||
How do you create a page border in Excel? | Excel Discussion (Misc queries) | |||
How to create thin cell border | Excel Discussion (Misc queries) |