Color

[Justin]

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

= IF C4-C5>0 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?

[VN]

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

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-C5>0 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?