Is auto format possible with =sheet1!A1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James E Middleton - 03 Apr 2007 08:56 GMT

I am using: =sheet1!=A1 to show information on sheet2 A1.

The data shows up fine, the format does not.

For example, Sheet1 A1 is Times New Roman 10pt.

Sheet2 A1 shows Times New Roman 10pt.

Sheet1 A1 is formatted Arial 12pt bold, Sheet2 A1 still shows Times New
Roman 10pt.

Even if I start with one page formatted as I like before I use the formula,
the data still come through without the format.

Is there a simpler way than using 'Format Painter'?

Reply to this Message

Pete_UK - 03 Apr 2007 09:40 GMT

You can not change the format of a cell with a formula - a formula can
only return a result. You need to set the format manually.

Pete

> I am using: =sheet1!=A1 to show information on sheet2 A1.
>
[quoted text clipped - 11 lines]
>
> Is there a simpler way than using 'Format Painter'?

Reply to this Message

James E Middleton - 03 Apr 2007 09:45 GMT

Thanks very much.

Probably beyond basics, but is there a way to insert a picture in a cell of
a worksheet and have it show up on another sheet?

> You can not change the format of a cell with a formula - a formula can
> only return a result. You need to set the format manually.
[quoted text clipped - 17 lines]
>>
>> Is there a simpler way than using 'Format Painter'?

Reply to this Message

Pete_UK - 04 Apr 2007 18:14 GMT

I've never played about with pictures very much, so I can't help you
with this one - sorry.

Pete

> Thanks very much.
>
[quoted text clipped - 24 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: