Can Text Function change output text color?

[epiekarc]

Hello,

The folowing forumal is used in part of a CONCATENATE function, and
everything works great, except the code below doesn't make the text red.

=TEXT(VLOOKUP(vUtility_Company,Table4,7,FALSE),"[<=9999999][Red]###-####;[Red](###) ###-####")

Any ideas how to get the text red only in the portion above and not the
whole CONCATENATE statement?

 

[Ron Rosenfeld]

Hello,

The folowing forumal is used in part of a CONCATENATE function, and
everything works great, except the code below doesn't make the text red.

=TEXT(VLOOKUP(vUtility_Company,Table4,7,FALSE),"[<=9999999][Red]###-####;[Red](###) ###-####")

Any ideas how to get the text red only in the portion above and not the
whole CONCATENATE statement?

You will need to execute a VBA Macro which
does the concatenation
writes the text string to the cell
then formats the particular portion in accordance with your formatting
rules.

Differential formatting, of the type you describe, can only be done on a text
string.
--ron