Fill Effects on Fill Color

[Guest]

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

 

[Guest]

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