Picture behind text in Cells

Hi Bezza


Take a textbox from the drawing toolbar and put it over the picture.
Select it. Enter =A1 in Excel's formula bar and the textbox will reflect the
content of cell A1 at all times.
Maybe format the box transparent background, no line, colored font, ...

HTH. Best wishes Harald

"Bezza" <adam_beresford@baa.com> skrev i melding
news:1112700797.479298.285670@g14g2000cwa.googlegroups.com...
> Is there any way in which a picture can be sent behind the text in the
> worksheet cells?
>
> Or round the other way, is there any way to show the cells contents in
> front of a picture?
>
> Many thanks
>
> Bezza
>

Thanks for all your replies, they are all valid answers, problem is
none of them can be used in formulas.

Essentially what I need to do is put some numbers in front of an image
and use the numbers in a formula.

I'm trying to use a spreadsheet to document all our computer cabinet
layouts, using images of the server and putting power and heat outputs
over the top. I then want to be able to total up the cabinet and
provide a sub-total. All these sub-totals can then be added together to
provide total figures for the data centre.

Bezza

Thanks for all your replies, they are all valid answers, problem is
none of them can be used in formulas.

Essentially what I need to do is put some numbers in front of an image
and use the numbers in a formula.

I'm trying to use a spreadsheet to document all our computer cabinet
layouts, using images of the server and putting power and heat outputs
over the top. I then want to be able to total up the cabinet and
provide a sub-total. All these sub-totals can then be added together to
provide total figures for the data centre.

Bezza

Can you put the pictures in one column and the numbers in the next(or
previous) column?

Bill

"Bezza" <adam_beresford@baa.com> wrote in message
news:1112785399.362295.203920@l41g2000cwc.googlegroups.com...
Thanks for all your replies, they are all valid answers, problem is
none of them can be used in formulas.

Essentially what I need to do is put some numbers in front of an image
and use the numbers in a formula.

I'm trying to use a spreadsheet to document all our computer cabinet
layouts, using images of the server and putting power and heat outputs
over the top. I then want to be able to total up the cabinet and
provide a sub-total. All these sub-totals can then be added together to
provide total figures for the data centre.

Bezza