using color for if function

[surfishingfool]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) For instance, I would like to make the sheet operate so as,

If a number is positive, it is black
If a number is negative, it is red

instead of manually changing the color of each negative number

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) For instance, I
would like to make the sheet operate so as,

If a number is positive, it is black
If a number is negative, it is red

instead of manually changing the color of each negative number

There are several standard formats that do this. Or, you can use a
custom number format. Look in help for an explanation. post back here if
you have any further questions.