In a formula, you don't. You would need to use vba

--
Don Guillett
SalesAid Software

"mtTry" wrote in message
...
this is my formula =IF('Input data'!K20,"to your new provider, "&'Input
data'!J2&", "&"your Total balance was: "&'Input data'!K3,"to your new
provider, "&'Input data'!J2&", "&"your Total balance was a Credit of :
"&'Input data'!L3). The result is:
to your new provider, Provider Name , your Total balance was a Credit of
:
$376.72
How do I get the "Provider Name" and "Credit" to appear in red?