Display Negative conditional amounts in K and M

[Wad Mabbit]

Yeah, I'm obsessive, but...,

OK, I have
[<1000]#;[<1000000]#.##,"K";#.##,,"M"

Which works great for positive numbers, now how about negative numbers as well (in RED, with a minus sign?

Thank you

 

[Wad Mabbit]

Yeah, I'm obsessive, but...,

OK, I have
[<1000]#;[<1000000]#.##,"K";#.##,,"M"

Which works great for positive numbers, now how about negative numbers as well (in RED, with a minus sign?

Thank you

PS
This formatting lea es an unsightly decimal point even if not needed to separate a value:
E.g. 3.K