Use conditional formatting on format menu for change color as you want.
use this formula in condition formatting for C4-C5 0
=C4C5

and use this formula in conditional formatting for C4-C5 < 0 in condition2
=C4<C5


"Justin" wrote:

How do you display a certain color in a cell for a formula for example in the
formula

= IF C4-C50 than display "Order", but display cell in red
but in same cell
= IF C4-C5<0 than display "No Order", but display in Green

I know it is confusing but how do I do this?