Font color for negative numbers

[Guest]

I need help in changing the font color for negative numbers to red in a
spread sheet
I have tried searching and then find using -$ find and it doesnt seem to work

 

[Bernard Liengme]

Try #,###.00_);[Red](#,###.00);0.00
The colors are [BLACK], [BLUE], [CYAN], [GREEN], [MAGENTA], [RED], [WHITE],
[YELLOW], [COLOR n] with n from 1 to 56
Also look here (found with Google search: Excel custom format
http://www.bettersolutions.com/excel/EVD243/QM215412021.htm
best wishes