SOLVED

Help with color formatting

Copper Contributor
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?
2 Replies
best response confirmed by AnnMiDiaz (Copper Contributor)
Solution

@AnnMiDiaz 

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.
1 best response

Accepted Solutions
best response confirmed by AnnMiDiaz (Copper Contributor)
Solution

@AnnMiDiaz 

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.

View solution in original post