using color for if function

S

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
 
B

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
Click to expand...
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.
 
Top