ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formatting Auto Shapes - Rectangle (https://www.excelbanter.com/excel-discussion-misc-queries/26883-formatting-auto-shapes-rectangle.html)

Woody13

Formatting Auto Shapes - Rectangle
 
I have created something but cannot recreate it and cannot remember what I
did differently. Clicked on Rectangle to form a perimeter around a few cells
and wanted it to look 3-D, which I have done in the past with the shadow
function, specifically shadow style 6. The rectangle I made transparent so
that I can see the numbers underneath. Now when I try this, the shadow does
not form correctly. Because its transparent I can see through it and see the
shadow line behind it instead of it looking like a white box with a grey
shadow. Hard to describe but can someone help? Thanks.

Duke Carey

Dont draw the rectangle - just select the cells and then apply the shadow.
Excel will create the transparent rectangle and shadow it correctly.

"Woody13" wrote:

I have created something but cannot recreate it and cannot remember what I
did differently. Clicked on Rectangle to form a perimeter around a few cells
and wanted it to look 3-D, which I have done in the past with the shadow
function, specifically shadow style 6. The rectangle I made transparent so
that I can see the numbers underneath. Now when I try this, the shadow does
not form correctly. Because its transparent I can see through it and see the
shadow line behind it instead of it looking like a white box with a grey
shadow. Hard to describe but can someone help? Thanks.



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com