View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default slanted cell shading

Add borders to those cells and then they will take the color formatting you
wish.

hth
Vaya con Dios,
Chuck, CABGx3



"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.

I have already changed the Orientation 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.
Please help!
Thanks!