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?