slanted cell shading

[Guest]

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.

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!

 

[Guest]

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

hth
Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

Sorry, I forgot to mention that in my original response.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Gord Dibben]

I mentioned it in my original post and OP missed it apparently.

Gord

Sorry, I forgot to mention that in my original response.

Gord Dibben MS Excel MVP

 

[Ragdyer]

Must be a problem with the MS servers Gord.

I don't see either Bob's or your *first* posts.

Don't even see some of my own, the they've been responded to by the OPs.

 

[CLR]

Yeah, same here RD.........I was also missing some and finally did a
"Headers" on IE5 and some more came in, but I had to do it on each
newsgroup.............

Vaya con Dios,
Chuck, CABGx3

Must be a problem with the MS servers Gord.

I don't see either Bob's or your *first* posts.

Don't even see some of my own, the they've been responded to by the OPs.
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

I mentioned it in my original post and OP missed it apparently.

Gord

 

[Ragdyer]

Usually, when I access the groups from another machine, like when I get
home,
I'll find some, if not all, of what I didn't see at the plant.

This was *bad* maybe a couple of years ago.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Yeah, same here RD.........I was also missing some and finally did a
"Headers" on IE5 and some more came in, but I had to do it on each
newsgroup.............

Vaya con Dios,
Chuck, CABGx3

Must be a problem with the MS servers Gord.

I don't see either Bob's or your *first* posts.

Don't even see some of my own, the they've been responded to by the OPs.
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

 

[Gord Dibben]

Could be the servers, as you say.

Gord

Must be a problem with the MS servers Gord.

I don't see either Bob's or your *first* posts.

Don't even see some of my own, the they've been responded to by the OPs.

Gord Dibben MS Excel MVP

 

[Bob Phillips]

Yeah, there was a response yesterday on another thread where the OP
mentioned a suggestion by Rick, but Rick's reply just didn't show in the
thread I was looking at. I had to Google it to see it.

--
HTH

Bob Phillips

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

Must be a problem with the MS servers Gord.

I don't see either Bob's or your *first* posts.

Don't even see some of my own, the they've been responded to by the OPs.
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

I mentioned it in my original post and OP missed it apparently.

Gord