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

--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)






"Jennifer"
wrote in message
ng.com...
Thank you Jim. Tried it and we're close. What I need is to compare these cells and if the result
is a positive number, it should display in Green font. Or if it's a negative number, it should
display in red. If the cells are equal, the cell should be left blank.
Thanks again.
My teacher is really vague on these formulas.





Jim Cone wrote:
The number of right facing parenthesis "(" must equal the number of left facing parenthesis ")".
You need a couple more ")" at the right end.

That doesn't make the formula correct however. I believe it should look like this...
=IF(C1C2,C2-C1,IF(C1<C2,C2-C1,""))
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)




"Jennifer"
wrote in message
ng.com...
Hi,

Could someone tell me what's wrong with this formula?

=IF((C1=C2),"",OR(IF((C1C2),"C2-C1"),OR(IF((C1<C2),"C2-C1"))
Thank you.