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 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.
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.