View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
duvanderz duvanderz is offline
external usenet poster
 
Posts: 4
Default 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!