Cell reference formatting

[skicamel]

Scenario:

Cell A1 contains whatever data
Cell A2 contains formula : =A1

Any data changed in A1 obvoiusly changes A2.

Is it possible to change the format of A2 based on the format of A1 as well? i.e. Set A1 to bold, and automatically have A2 changed to bold?

Found ways to get close with VB, but not to the point where the changes propagate on format change alone.

Thanks in advance...

 

[SkipVought]

Not with native spreadsheet functionality.

Format > Conditional Formatting works based on VALUES, not FORMATS.

Do a search in Tek-Tips, because s0mething similar has been addressed.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]