Text Color Functions

[Mark Schreiber]

Does Excel have any text formatting functions that change the color of the
text? For example, I have a cost spreadsheet that calculates the savings
achieved or excess cost of a project. It is a very easy matter to apply
conditional formatting to the worksheet cells where those values, but that is
not what I need. I am using the TEXT() function to pull those values into
another location as text, and would like to be able to carry their color
formatting with them somehow, so that in the transfer cell containing the
TEXT() function formula, a savings will still display as green font and a
cost overrun still display as red font. Is there some kind of
TEXT(FONTCOLOR("&HF00F"), "$##,###) function that will do this? I'm sure it
can be done with some VBA coding, but user-defined functions slow down the
application, and I have hundreds of cells containing the information I am
trying to format. Any help would be appreciated. Thanks.

 

[Dave Peterson]

No.

Formulas retrieve values from the sending cells--not this kind of formatting.

Depending on how that sending cell changes, you may be able to use a worksheet
event (either _Calculate or _change).