How do I format linked cells?
 

I have a workbook containing information that will be used by our line staff.
It contains 2 sheets. Sheet1 all the information to be used by staff,
including additional information needed by our Quality department. Some of
the information on Sheet1 is linked to create sheet2, cell by cell, using the
formula ='sheet1'!A1. Sheet 1 is considered the "master" copy that will be
updated if there are changes.

Some cells on sheet1 contain formatting (underlining, bold, etc) of some of
the text. The text is displaying on Sheet2, but the formatting is not. Is
there a way that this formatting can also display sheet2?

Thanks for your help!
Deb Baedke
QA Analyst
Blood Center of Iowa
Des Moines, IA

How do I format linked cells?
 

The link method does not link the formatting. Just copy the original cells
and paste/special formats onto the destination cells.
--
Gary''s Student
gsnu200701


"Deb_B" wrote:

I have a workbook containing information that will be used by our line staff.
It contains 2 sheets. Sheet1 all the information to be used by staff,
including additional information needed by our Quality department. Some of
the information on Sheet1 is linked to create sheet2, cell by cell, using the
formula ='sheet1'!A1. Sheet 1 is considered the "master" copy that will be
updated if there are changes.

Some cells on sheet1 contain formatting (underlining, bold, etc) of some of
the text. The text is displaying on Sheet2, but the formatting is not. Is
there a way that this formatting can also display sheet2?

Thanks for your help!
Deb Baedke
QA Analyst
Blood Center of Iowa
Des Moines, IA

How do I format linked cells?
 

Thanks for your reply. I was afraid of that.

"Gary''s Student" wrote:

The link method does not link the formatting. Just copy the original cells
and paste/special formats onto the destination cells.
--
Gary''s Student
gsnu200701


"Deb_B" wrote:

I have a workbook containing information that will be used by our line staff.
It contains 2 sheets. Sheet1 all the information to be used by staff,
including additional information needed by our Quality department. Some of
the information on Sheet1 is linked to create sheet2, cell by cell, using the
formula ='sheet1'!A1. Sheet 1 is considered the "master" copy that will be
updated if there are changes.

Some cells on sheet1 contain formatting (underlining, bold, etc) of some of
the text. The text is displaying on Sheet2, but the formatting is not. Is
there a way that this formatting can also display sheet2?

Thanks for your help!
Deb Baedke
QA Analyst
Blood Center of Iowa
Des Moines, IA

How do I format linked cells?
 

It's not that bad if you only have to do it once.
--
Gary's Student
gsnu200701


"Deb_B" wrote:

Thanks for your reply. I was afraid of that.

"Gary''s Student" wrote:

The link method does not link the formatting. Just copy the original cells
and paste/special formats onto the destination cells.
--
Gary''s Student
gsnu200701


"Deb_B" wrote:

I have a workbook containing information that will be used by our line staff.
It contains 2 sheets. Sheet1 all the information to be used by staff,
including additional information needed by our Quality department. Some of
the information on Sheet1 is linked to create sheet2, cell by cell, using the
formula ='sheet1'!A1. Sheet 1 is considered the "master" copy that will be
updated if there are changes.

Some cells on sheet1 contain formatting (underlining, bold, etc) of some of
the text. The text is displaying on Sheet2, but the formatting is not. Is
there a way that this formatting can also display sheet2?

Thanks for your help!
Deb Baedke
QA Analyst
Blood Center of Iowa
Des Moines, IA