Custom Number Format with Text/Numbers + Coloring

[Calambor]

Hello and thank you for your time,

I am trying to create a custom number format that allows me to create the below example:

If the formula for the cell results in a negative number it will display this:

(622) Negative

If the formula for the cell results in a positive number it will display this:

622 Positive


My current issue is when the numerical value is negative, I have to apply the red font color to both the "(622)" and the word "Negative". I only want the "(622)" to appear in red front, with black text for the word "Negative". I tried conditional formatting but it applies it to the entire cell.

 

[Calambor]

Sorry for not including this in my original post, but this is the current formula I have for the Custom Number Format:

[Black]#,##0_) "Positive";[Red](#,##0) "Negative"