Need to amend a formula to show negative numbers in red?

edit

'kiss' answer (keep it simple and stupid):

try this: [>0]" $"* #,##000" ";[<0][ROT]" $"* (-#,##000);" $"* -#" ";" "@" "

observe that i added a '-' sign, delete if not wanted,

probably you need to replace '[ROT]' - german by '[RED]' - english,

have fun

P.S. 'solved marks' and 'likes' welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the "^" above it if you 'like' the answer,
"v" if you don't,
do not! use 'answer' to add info to your question, either edit the question or add a comment,
'answer' only if you found a solution yourself ...

Let's see what the Number Format Codes Help says:

The first paragraph shows that we can set the color very easily with [RED]. The second paragraph explains that there is no need to set the conditions [> 0] and [<0] - it is enough to know that the first part of the format code will be applied to positive values, and the second to negative ones.

The easiest, fastest and most reliable way to solve your problem: press Ctrl+1 to open the Format - Cells - Numbers tab and check the Negative numbers in red