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...M215412021.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Regards" wrote in message
...
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