Create new border style?

[alexmoss]

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

 

[Dave Peterson]

Maybe you can create 3 styles. TopCell, BottomCell, MiddleCells.

Then apply each of the styles to each of the rows in your range.

(Yep, it's more work for you.)

 

[alexmoss]

Ah ha, sometimes the simple solution escapes me, thanks - I actually don't
need a separate style for the middle rows, I'm not changing those, so it's
just top and bottom.

And I suppose I could try to figure out a macro to apply the different
format to the various rows too -- not my strength, but likely not too hard.

Back to the first question: does anyone know how to create a multi-row style
that does this in 1 simple step?

Thanks again,
Alex

 

[Dave Peterson]

I don't.

Ah ha, sometimes the simple solution escapes me, thanks - I actually don't
need a separate style for the middle rows, I'm not changing those, so it's
just top and bottom.

And I suppose I could try to figure out a macro to apply the different
format to the various rows too -- not my strength, but likely not too hard.

Back to the first question: does anyone know how to create a multi-row style
that does this in 1 simple step?

Thanks again,
Alex

 

[alexmoss]

Ok, thanks again for the help so far, your suggestion is much better than
what I was doing (manual reformatting each time), and I'll hope someone else
might have some flash of brilliance here eventually.

Alex

 

[Dave Peterson]

In my simple tests (in xl2003), it didn't look possible to me. But maybe some
one knows a way and will post it.

 

[Bod]

Hitting F4 (redo) can be a massive time saver - make the change you want, go
to the next place you want to make the same change, hit F4.