View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mtTry mtTry is offline
external usenet poster
 
Posts: 3
Default 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?