Color

J

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?
 
V

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
 
Top