kshastry

Q: How to mirror another cell?

I want to make cell1 (A1) as mirror of cell2 (A2). From the content perspective, I can simply use "=A2" inside A1, and that should do. But let's say I want formatting also to be reflected in A1 whenever I make changes in A2 (font, font size, font color, background color etc.). Is there any advanced = option? :-) If not, it could be a cool enhancement, I feel.

 

Please let me know. Thanks in advance.

 

Regards,

Krishna.

Posted on Sep 9, 2016 2:44 PM

Close

Q: How to mirror another cell?

  • All replies
  • Helpful answers

  • by t quinn,

    t quinn t quinn Sep 9, 2016 5:53 PM in response to kshastry
    Level 5 (5,041 points)
    Mac OS X
    Sep 9, 2016 5:53 PM in response to kshastry

    Hi Krishna,

     

    As far as I know there is no way to link formatting between cells. If there are conditions that would lead you to change the formatting- certain text, values in a certain range, etc. then check out conditional formatting.

    Screen Shot 2016-09-09 at 6.50.51 PM.png

    If you are looking to make a feature request you should go to Provide Numbers Feedback

    Screen Shot 2016-09-09 at 6.52.00 PM.png

    We are users like yourself and do not have any sway with Apple.

     

    quinn