Ron Rosenfeld wrote:
On Wed, 29 Jun 2011 10:55:06 -0700, "Jim Cone" wrote:

You do that with a custom number format...
[Green]General;[Red]General;General

That should be:

[Green]General;[Red]General;

(Omit the last General, but NOT the last semi-colon, in order to have zero be blank).

To elaborate for Jennifer, your cell containing the formula should contain:

=C1-C2

Then Right Click on that cell and select
Format/Number/Custom Type:
and enter: [Green]General;[Red]General;

Thank you guys. I appreciate it.