I'm looking for a way to link a cell or group of cells both to the values of another cell/range and to the formatting of that cell/range. For instance, in cell A1 I have the formula =N10 so that the value in cell A1 changes as cell N10 is updated. How can I also get the formatting in cell A1 to change as the formatting in cell N10 changes?
Thank you for any help you can offer on this.
Thank you for any help you can offer on this.