half cell shading
 

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please help!

half cell shading
 

It is not half cell shading, it is slanting text with a cell background. The
slanting text is obtained via FormatCellsAlignment and set the
orientation.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"duvanderz" wrote in message
...
I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please
help!

half cell shading
 

I have already changed the Orentation and have the text set at a 68º angle.
Whenever I try to shade the area (left click cell, right click, format cells,
Patterns, and choose a cell shading color) it shades the whole block and not
just the diagonal area.

Please explain in detail how I am to get this diagonal shading effect. I
have already worked the text angle.
Thanks!


"Bob Phillips" wrote:

It is not half cell shading, it is slanting text with a cell background. The
slanting text is obtained via FormatCellsAlignment and set the
orientation.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"duvanderz" wrote in message
...
I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please
help!

half cell shading
 

You cannot shade half a cell.

What you are seeing is cells with the text angled at 60 degrees using
FormatCellsAlignmentOrientation.

You also cannot angle a cell, just the text within.

Adding borders and color gives the appearance of an angled cell.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:11:01 -0700, duvanderz
wrote:

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please help!

half cell shading
 

I understand about the Orientation, I have understood that from the
beginning. I have mine set at 68º
What I'm trying to learn is "how do I make the appearance of a slanted
shading?"

Please realize I know I can't slant a cell, and I now know I can't shade
half a cell. What I'm asking is how to I create the appearance of a slanted
cell?

If anything, someone please tell me how to create it from scratch and I'll
plug in where I need to. Thank you in advance.


"Gord Dibben" wrote:

You cannot shade half a cell.

What you are seeing is cells with the text angled at 60 degrees using
FormatCellsAlignmentOrientation.

You also cannot angle a cell, just the text within.

Adding borders and color gives the appearance of an angled cell.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:11:01 -0700, duvanderz
wrote:

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please help!

half cell shading
 

Read my post again.

Once the cell text is set to 68 degrees, add an outline border and color.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 11:22:01 -0700, duvanderz
wrote:

I understand about the Orientation, I have understood that from the
beginning. I have mine set at 68º
What I'm trying to learn is "how do I make the appearance of a slanted
shading?"

Please realize I know I can't slant a cell, and I now know I can't shade
half a cell. What I'm asking is how to I create the appearance of a slanted
cell?

If anything, someone please tell me how to create it from scratch and I'll
plug in where I need to. Thank you in advance.


"Gord Dibben" wrote:

You cannot shade half a cell.

What you are seeing is cells with the text angled at 60 degrees using
FormatCellsAlignmentOrientation.

You also cannot angle a cell, just the text within.

Adding borders and color gives the appearance of an angled cell.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 10:11:01 -0700, duvanderz
wrote:

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please help!

half cell shading
 

Picture 2 is what you are trying to get I assume, I followed the instrctions
on the supplied link and got it to work, step 5 follwed by change the font
color to a color, then change the fill color click ok. the text should change
color and rotate to look like it is filling half the cell
--

Neil



"duvanderz" wrote:

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/as...097991033.ASPX

I'm trying to get the diagonal shading. Everytime I try to shade an area,
it shades the whole cell, and I'm only wishing to shade half. Please help!