Text Color Functions

[Mark Schreiber]

Is there a function equivalent to TEXT() that will change the font color in a
cell? I am using TEXT() to carry forward expense info as text. In the
original cells, if there is a savings, conditional formatting was used to
change the font to green, and if there was a cost overrun, the formatting
changes the font to red. I want to carry that formatting along with the
text. So, if cell B10 contains the value "1500", formatted as currency, it
shows up green as "$1,500.00". Now say in cell D6 I enter
"=TEXT(B10,"$#,###.##)" it still displays as "$1,500.00", but now the font is
black. It needs to be green, as before. Since there are hundreds of cells
in this workbook that do this, I don't want to write a big VBA user-defined
function, because that would significantly slow down the running of the
spreadsheet every time I enter a new value. Any ideas?

 

[T. Valko]

Formulas can't pull formatting from other cells.

What's wrong with conditional formatting?

 

[Mark Schreiber]

Conditional formatting is great for worksheet cells, and I use it
extensively. But in this case I am using TEXT() and "&" functions to build a
string into a worksheet cell, then referencing the contents of that cell into
a text box embedded on a chart. I am trying to get the formatting to show up
in the text box.