Link to Values and Formatting

[JAF7]

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.

 

[millhouse123]

In reguards to formatting, do you want the fonts to be the same or color or what property do you want changed based on values.

 

[JAF7]

I was hoping for all the formatting (borders, colors, fonts, etc.). Does that answer your question?

 

[millhouse123]

Shouldn't you be able to use conditional formatting?

 

[JAF7]

Not that I'm aware of, but maybe I don't know it well enough.