format results of a formula

M

mtTry

this is my formula =IF('Input data'!K2>0,"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?
 
S

SamuelT

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
 
S

SamuelT

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
 
D

Don Guillett

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
 
Top