Format Referencing

L

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?
 
D

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.
 
L

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.
 
D

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.
Click to expand...
 
L

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
 
D

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.
 
L

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?
 
D

Dave Peterson

Not that I know.
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?
Click to expand...
 
Top