format text color within formula

[St@cy]

I've done something like this before, but I can't remember now how to format
text colors within a formula.
Please help me fix the following:

=CONCATENATE("Current ";[Green], W19;[Green]," Status";[White])

 

[Peo Sjoblom]

Not possible format part of a formula with regards to colour, font etc


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)