Linking cells with changing format
 

Hello people

I was wondering if its possible to copy a cell (from one tab of a document
to another) and have them linked so that the format will change in the new
cell if the format of the original is changed...

Thanks for any suggestions :-)

Linking cells with changing format
 

Just saw the previous post... What are the odds of two people asking the same
thing at the same time!

Doesnt look hopeful unfortunately but I'll keep an eye on the other thread
to see the answers.

"Wombat" wrote:

Hello people

I was wondering if its possible to copy a cell (from one tab of a document
to another) and have them linked so that the format will change in the new
cell if the format of the original is changed...

Thanks for any suggestions :-)

Linking cells with changing format
 

Use same CF on both cells.


Gord Dibben MS Excel MVP

On Tue, 6 Oct 2009 05:43:01 -0700, Wombat
wrote:

Just saw the previous post... What are the odds of two people asking the same
thing at the same time!

Doesnt look hopeful unfortunately but I'll keep an eye on the other thread
to see the answers.

"Wombat" wrote:

Hello people

I was wondering if its possible to copy a cell (from one tab of a document
to another) and have them linked so that the format will change in the new
cell if the format of the original is changed...

Thanks for any suggestions :-)

Linking cells with changing format
 

Too many variables :-(

"Gord Dibben" wrote:

Use same CF on both cells.


Gord Dibben MS Excel MVP

On Tue, 6 Oct 2009 05:43:01 -0700, Wombat
wrote:

Just saw the previous post... What are the odds of two people asking the same
thing at the same time!

Doesnt look hopeful unfortunately but I'll keep an eye on the other thread
to see the answers.

"Wombat" wrote:

Hello people

I was wondering if its possible to copy a cell (from one tab of a document
to another) and have them linked so that the format will change in the new
cell if the format of the original is changed...

Thanks for any suggestions :-)