Forum Discussion
Solved
Help with color formatting
I’m trying to turn a cell green if the value is greater than 0 and red if it less than. The cell I’m trying to put the rule in already uses a formula that subtract from two values an shows the result the formula is: =IMSUB(K18,I18). I have tried the usual conditional formatting and although it does turn to green when the value is greater than 0 it doesn't do anything when the numbers are negative. What do I need to do?
The IMSUB function is for use with complex numbers of the form a+bi where i is the square root of -1.
The result of IMSUB is a text value representing a complex number.
Unless you are actually working with such numbers, you should change the formula to=K18-I18. Standard conditional formatting rules should then work.
2 Replies
The IMSUB function is for use with complex numbers of the form a+bi where i is the square root of -1.
The result of IMSUB is a text value representing a complex number.
Unless you are actually working with such numbers, you should change the formula to=K18-I18. Standard conditional formatting rules should then work.
- Thank you, that worked. As you can see I’m no expert and was very confused.
