Look at Format | Cell and choose the NUMBER category - there are several
predefined types for negative numbers, including red and red in parenthesis.
If you specifically need red and negative symbol vs red in parenthesis, use
the Custom format and type in the following:
$#,##0.00_);[Red]-$#,##0.00
(leave the $ symbols out of it if you're not working with currency).

"Gene" wrote:

Thanks for the first step

That did work in one case but I still need to have a cel' "sign" changed. as
it is now I can change the color to read but is does not change it to a -
number so that it will show brackets as a negitive number.

If printed in b/w, i could not now tell that it is a negitive number.

Got to find a step to convert "+" numbers into "-" numbers.

G

"JLatham" wrote:

Use Conditional Formating. It is an option under Format in the menu bar.

"Gene" wrote:

I have an expense sheet calculated, need to show the sum of the "+" number in
a cell that does a subtraction of 2 numbers .. income and subsidized ... as a
- that it negitave amount in red if it is less than a specific numbe. ie 2500

Any suggestions?