SOLVED

Help with color formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1599779%22%20slang%3D%22en-US%22%3EHelp%20with%20color%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599779%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20trying%20to%20turn%20a%20cell%20green%20if%20the%20value%20is%20greater%20than%200%20and%20red%20if%20it%20less%20than.%20The%20cell%20I%E2%80%99m%20trying%20to%20put%20the%20rule%20in%20already%20uses%20a%20formula%20that%20subtract%20from%20two%20values%20an%20shows%20the%20result%20the%20formula%20is%3A%20%3DIMSUB(K18%2CI18).%20I%20have%20tried%20the%20usual%20conditional%20formatting%20and%20although%20it%20does%20turn%20to%20green%20when%20the%20value%20is%20greater%20than%200%20it%20doesn't%20do%20anything%20when%20the%20numbers%20are%20negative.%20What%20do%20I%20need%20to%20do%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1599779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599816%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20color%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F764953%22%20target%3D%22_blank%22%3E%40AnnMiDiaz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20IMSUB%20function%20is%20for%20use%20with%20complex%20numbers%20of%20the%20form%20a%2Bbi%20where%20i%20is%20the%20square%20root%20of%20-1.%3C%2FP%3E%0A%3CP%3EThe%20result%20of%20IMSUB%20is%20a%20text%20value%20representing%20a%20complex%20number.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnless%20you%20are%20actually%20working%20with%20such%20numbers%2C%20you%20should%20change%20the%20formula%20to%3DK18-I18.%20Standard%20conditional%20formatting%20rules%20should%20then%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599912%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20color%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599912%22%20slang%3D%22en-US%22%3EThank%20you%2C%20that%20worked.%20As%20you%20can%20see%20I%E2%80%99m%20no%20expert%20and%20was%20very%20confused.%3C%2FLINGO-BODY%3E
New 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 (New 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.