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?

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?

Conditional formatting should do the trick.

Format Conditional Formatting

Then do:

Cell Value l Is Equal To l Credit

Select the formatting you want (i.e. red).

Click the Add button and do the same for 'Provider Name'

HTH,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=563332

Conditional formatting should do the trick.

Format Conditional Formatting

Then do:

Cell Value l Is Equal To l Credit

Select the formatting you want (i.e. red).

Click the Add button and do the same for 'Provider Name'

HTH,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=563332

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?

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?

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?

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?