I have search forums for hours to find a solution to what I initially though would be an easy task, it has however proved most difficult for a relatively noob like me.

Basically I need to link a regular text box (i.e. insert tab, text box) to another cell and keep the formatting. i.e. if the colour of the text in the cell I am linking is red, I need the colour of the text in the text box to be red (in this case negative numbers). This needs to be able to be updated live as I have so many text boxes and they are set up to change values when the underlying data changes (sometimes negative numbers some times positive numbers)

Is it possible for the text box to mimic the formatting of the linked data? or do I have to go down the line of conditionally formatting the text boxes? if so, how?? I can only find info on formatting activex text boxes and I cant use these as i need to be able to rotate the boxes.

Any help would be so much appreciated. I am going grey!