How to condition cells that have a formula, not a value in Excel?

I have one sheet where I track my monthly household income and costs. Column A contains the description of the costs, starting at row 3. Column C is the month January, column D is February, until col...

excel

Formulas and Functions

Riny_van_Eekelen
Jul 11, 2022
Sebas2335 Firstly, why use IMSUB? That function is used to calculate with imaginary numbers and it returns a text. Just use =M31-C31, of if you want =SUM(-C31,M31)

Conditional formatting looks at the value of the cell. That can be one that is entered directly or one resulting from a formula. Your attempts failed as you tried to format the textual outcome of IMSUB based on numerical criteria.

Riny_van_Eekelen

Platinum Contributor

Jul 11, 2022

Sebas2335 Firstly, why use IMSUB? That function is used to calculate with imaginary numbers and it returns a text. Just use =M31-C31, of if you want =SUM(-C31,M31)

Conditional formatting looks at the value of the cell. That can be one that is entered directly or one resulting from a formula. Your attempts failed as you tried to format the textual outcome of IMSUB based on numerical criteria.

Sebas2335
Copper Contributor
Jul 11, 2022
That worked great. Thank you for the explanation, used the wrong formula. Cheers!

Forum Discussion

How to condition cells that have a formula, not a value in Excel?

Resources