half cell shading

[duvanderz]

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/assistance/HA011097991033.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!

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

I am wishing to create the shading as shown on the 2nd image/chart on this
page:
http://office.microsoft.com/en-us/assistance/HA011097991033.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!

 

[duvanderz]

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!

 

[Gord Dibben]

You cannot shade half a cell.

What you are seeing is cells with the text angled at 60 degrees using
Format>Cells>Alignment>Orientation.

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

 

[duvanderz]

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]

Read my post again.

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


Gord Dibben MS Excel MVP

 

[Neil]

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