Highlight the cell or group of cells in question then choose Format, Cells, Number, Number then choose Negative Numbers shown in red. At least that's how you do it in Excel 2003.
--------------------
Do you know that we're all in line for succession to the throne? Really?
Well, if forty-eight million, two hundred thousand, seven hundred and one people died I'd be Queen.