Send me your file along with copies of this thread and details of what you
want.

--
Don Guillett
SalesAid Software

"mtTry" wrote in message
...
Thanks Don, it didn't seem to work for me. Got any other ideas?

"Don Guillett" wrote:

Use this idea. Be advised that your formula is no longer a formula.

Sub makepartred()
With Worksheets("Sheet14").Range("a4")
.Value = .Value 'changes to value
.Characters(2, 3).Font.ColorIndex = 3
End With
End Sub

--
Don Guillett
SalesAid Software

"mtTry" wrote in message
...
Sorry to be dense but how would I use vba to format my result?

"Don Guillett" wrote:

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?