Hello, so I am looking to find a way to have two cells from separate worksheets link together such that when either one is changed, the other one updates. I figured this out with the help of this forum by using this code:
Now this works fine, however there is another layer I am trying to solve now. I am trying to use multiple fonts within a cell, specifically attempting to use a font called "isoqsymbol" for specific symbols and just use "arial" for numerical values. My problem is whenever I change a numerical value or symbol, the linked cell in the other sheet updates in just plain "arial" font, leaving the symbol font out and making the cell illegible. Is there any way to keep font formatting linked along with the value? Please let me know if this is possible - or will I have to separate cells. Thank you so much.
Bookmarks