Excel - rotate entire cell and text 1

[kirstenlargent]

I need to rotate a cell in Excel. I know I can rotate the TEXT part of the cell by going to Format, Cells, and Alignment, but I need to rotate the actual FILL color that is also in the cell. (45 degree angle)
Someone sent me a worksheet where the fill was also rotated, but I can not figure out how they did that.
Any suggestions?
THANKS!

 

[ETID]

go to "patterns tab" (format cells) choose "reverse diagonal lines

 

[kirstenlargent]

I just tried it, and all that did is draw diagonal lines in the cell, but the cell was still an upright rectangle, instead of having the fill slanted at 45 degrees to match the text.
Any thoughts?!

 

[ETID]

...maybe the cowards way, but...can you copy from the sheet that someone sent to you, and paste special > formats into your sheet?

 

[AnotherHiggins]

This line,

...but the cell was still an upright rectangle...

got me wondering.... Are you trying to change the actual cell itself to be slanted?

If so, Excel don't play that.

If not, what kind of "fill" do you currently have in the cell that you are trying to slant? And what version Excel are you on?

John

Every generalization is false, including this one.
-Unknown

 

[kirstenlargent]

I tried copying and pasting, but it didn't work.

Someone here just figured it out - if you put a Border around the cell, it will then slant the fill of that cell.

No border, no slant. Go figure!

Thanks!