Aug 19 2020 01:04 PM - edited Aug 19 2020 01:06 PM
Aug 19 2020 01:17 PM
SolutionThe 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.
Aug 19 2020 02:07 PM
Aug 19 2020 01:17 PM
SolutionThe 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.