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)
"St@cy" wrote in message
...
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])