How to make negative currency red with negative sign

[Gettingbetter15]

[FONT=&quot]Looking online, I found the command below to turn negative currency red with a negative sign, but it didn't work for me. The result I got is red currency with no negative sign.

$#,##0.00;[Red]-$#,##0.00

Can anyone help me please? TIA![/FONT]

 

[Special-K99]

Works fine for me.

In a blank sheet enter 13 in B2, enter -12 in B3.
Select B2:B3
Custom format the cells with the format you specified.
B2 remains black and displays as $13.00
B3 turns red and displays as -$12.00

 

[Gettingbetter15]

I guess it might actually work if the result was a negative number! Thank you, Special-K99. My formula was backwards, resulting in an (incorrect) positive value. Have a great day!