Format for 3 D reference

When referencing a cell in a worksheet in another worksheet, is there a way to have the formatting from the referenced cell automatically be the same in the referencing cell?

For example:
Worksheet1, cell A1 has bold formatting.

Therefore, in worksheet2, you reference Worksheet1!A1. Can the formatting from worksheet!a1 be automatically applied in worksheet2 that is referencing Worksheet1?

--
D

Hi
no, not possible

--
Regards
Frank Kabel
Frankfurt, Germany


Dan wrote:
When referencing a cell in a worksheet in another worksheet, is there
a way to have the formatting from the referenced cell automatically
be the same in the referencing cell?

For example:
Worksheet1, cell A1 has bold formatting.

Therefore, in worksheet2, you reference Worksheet1!A1. Can the
formatting from worksheet!a1 be automatically applied in worksheet2
that is referencing Worksheet1?

"Frank Kabel" wrote...
no, not possible

Not with a formula, but you could do this with a picture link. And it'd also be
possible to use a Calculate event handler to iterate through all cells looking
for formulas that are simple references to cells in other worksheets, then apply
those cells' formats to the cells containing the formulas.

Dan wrote:
When referencing a cell in a worksheet in another worksheet, is there
a way to have the formatting from the referenced cell automatically
be the same in the referencing cell?
...

--
To top-post is human, to bottom-post and snip is sublime.

Harlan Grove wrote:
"Frank Kabel" wrote...
no, not possible

Not with a formula, but you could do this with a picture link. And
it'd also be possible to use a Calculate event handler to iterate
through all cells looking for formulas that are simple references to
cells in other worksheets, then apply those cells' formats to the
cells containing the formulas.

Hi Harlan
a picture link is something I've never tried :-)
For the worksheet_calculate event: This is only nearly automatic as
this won't be triggered if you only change the format.
Another option (with the same restriction) would be to use the OnTime
method

Frank

One way:

Put this in the worksheet 2 code module (right-click the worksheet 2 tab
and choose view code):

Private Sub Worksheet_Activate()
Dim rCell As Range
For Each rCell In Range("A1,J10")
With rCell
Worksheets("Sheet1").Range(.Address).Copy
.PasteSpecial Paste:=xlFormats
End With
Next rCell
End Sub



In article ,
Dan wrote:

When referencing a cell in a worksheet in another worksheet, is there a way
to have the formatting from the referenced cell automatically be the same in
the referencing cell?

For example:
Worksheet1, cell A1 has bold formatting.

Therefore, in worksheet2, you reference Worksheet1!A1. Can the formatting
from worksheet!a1 be automatically applied in worksheet2 that is referencing
Worksheet1?

"Frank Kabel" wrote...
...
For the worksheet_calculate event: This is only nearly automatic as
this won't be triggered if you only change the format.
Another option (with the same restriction) would be to use the OnTime
method

OnTime macros can really slow things down. Better to call

Application.Calculate

from BeforePrint and BeforeSave macros, though that won't help on screen only
use.

--
To top-post is human, to bottom-post and snip is sublime.

In article ,
Harlan wrote:

OnTime macros can really slow things down. Better to call

Application.Calculate

from BeforePrint and BeforeSave macros, though that won't help on screen only
use.

Unless somehow the formats on the other sheet will change while the
target sheet is displayed (e.g., via macro), in most cases using the
Activate event will update the format for screen use.

One scenario where it fails is when there are two or more windows for
the workbook and the format is changed in window 1 - the update won't
occur until the other window (or the target worksheet in window 1) is
selected.