I have a text box linked to a cell in a table in the same workbook.
I want to have the font color of the text to reflect that which is in the
cell.
e.g. I have a dollar figure in the cell. It is in a black front for positive
values, and red with parenthese () for negitive figures. At present, I have a
negitive dollar figure which reflects in the sheet as a black $(3,813.47).

How can I make the font format in the text box follow the spreadsheet's
format?