|As far as I know, you can not change the color of part of a text string via a formula.|
I do know that it can be done with VBA, but the cell must contain text, not a formula.
This code will place the string you are using in A2 and color the number red if the number in A1 is negative. As written, it needs to be run manually, but if you'll supply some details as to how the number in A1 is changed, there may be a way to automate it.
Range("A2") = "Let's try to get color in the result ($" & Range("A1") & ")"
If Range("A1") < 0 Then
Range("A2") = "Let's try to get color in the result ($" & Range("A1") * -1 & ")"
startChar = InStr(Range("A2"), "(")
endChar = InStr(Range("A2"), ")") + 1
(Start:=startChar, Length:=endChar - startChar).Font.ColorIndex = 3
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.