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

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 wrote:

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

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" wrote:

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 wrote:

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

I don't.

alexmoss wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

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" wrote:

I don't.

alexmoss wrote:

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" wrote:

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 wrote:

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


--

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.

alexmoss wrote:

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" wrote:

I don't.

alexmoss wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

--

Dave Peterson