format results of a formula
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?
|