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.