Search code examples
excelreferencecell

More Robust Form of Excel Cell Referencing

I often use cell referencing for single use or nearly entire sheets. I can not find a way to do cell referencing which transposes cell format (bold, italics, cell fill, etc.) along with the context.

EDIT: Summary I am trying to get one cell which references another cell in another worksheet to also reflect changes in format (bold, cell fill, etc.) and not just value

Any help or direction is appreciated.

Thanks.

Solution

  • Maybe not super robust but paste as linked picture does what you want:

    enter image description here