![]() |
Fill Effects on Fill Color
I am trying to add some Fill Effects to a regular color filled cell which
contains text. I can't seem to find where it is possible. I have tried adding a Basic Shape from the Drawing Toolbar and have played with the transparency and fill effects to get the text to show through, but it looks ugly. Is there either a way to have the text entered into the sheet show in front of the drawing object, or add the same fill effects to a regular cell. Thanks - Doug - San Antonio |
Rugdoody,
The only workaround I can think of is to create a textbox and link it to the cell whose value you want to display. To link it, select the textbox and type "=" and the cell reference in the formula bar. For example, "=A1" to refer to cell A1. The value in the cell should appear in the text box. You can add fill effects to the textbox and the text should appear over it. Eric "Rugdoody" wrote: I am trying to add some Fill Effects to a regular color filled cell which contains text. I can't seem to find where it is possible. I have tried adding a Basic Shape from the Drawing Toolbar and have played with the transparency and fill effects to get the text to show through, but it looks ugly. Is there either a way to have the text entered into the sheet show in front of the drawing object, or add the same fill effects to a regular cell. Thanks - Doug - San Antonio |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com