Format Referencing

[londar]

How can I make it so not only the values in the cell but the formatting
to that cell is referenced as well. Take for example I have a number
"22" in a cell, but it is bolded and italicized as well as centered.
Is there a way to copy these formats over as well?

 

[Dave Peterson]

If you're using a formula (like =A1), then formulas don't work like that. They
return values.

But you could Edit|copy and Edit|paste to copy the cell.

 

[londar]

I need it to be dynamically referenced so any changes to that cell would
be reflected on the new page.

So basically =Sheet1!A1 + I want all the cell formatting that goes
along with it.

 

[Dave Peterson]

formulas don't work like that.

I need it to be dynamically referenced so any changes to that cell would
be reflected on the new page.

So basically =Sheet1!A1 + I want all the cell formatting that goes
along with it.

 

[londar]

well then would there be a way to reference an entire worksheet to wor
the same as a template page.

Basically what I am trying to create is somthing for my company so whe
I add a new location, it creates a new worksheet and all thes
worksheets look the exact same so when the customer comes in the forma
is easy to read and stylized to their liking

 

[Dave Peterson]

You could copy and paste. Then the formatting will travel with the paste. But
the "receiving" cell won't change format if you change the "sending" cell's
format.

 

[londar]

Alright then is there a way to reference the format of an entire
worksheet, different sizing for different cells, have THAT remain
static, or linked to a template page, and the value of the cells
referenced from another?