This is driving me insane as I cannot figure out why my formulas that equal 0, are showing as a RED color.   I am adding up two cells.  One cell is $102.60 (A1).  One cell is $84.30 (A2).  The total cell is $102.60+$84.30 = $186.90 (A3) These are all represented as "currency". I have another cell A9 that points to cell A3 and another cell B9 called "credits".  The equation is A9 minus B9 plus C9 equals D9. In the "credits" (B9) cell, I manually type in $186.90.  So $186.90 minus $186.90 should equal 0.

https://www.bleepingcomputer.com/forums/t/786332/excel-formulas-showing-red-for-zero/

#bleepingcomputer