go to the dropdown box for formatting cells, from the dropdown click more number formats then click on either number or currency. If you select number it should show in the list as as either showing negative numbers as red or one with parens around it and red. Same for currency and you can drop the currency sign. (which isn't that different than MrShorty's suggestion)