I am working on a solution. I wanted to color-code line items as they met a condition. Items are either "open" or "paid". For years, I have seen calculations result in 0.00 and -0.00. It was never an issue, zero is zero.
I wanted the line items with a balance to be "clear" i.e. not color, with the zero balance having a color. That did not work, for the -0.00. So I tried different formulas. My last attempt was using the ABS function.
I did try to use = 0 or =-0, and that did not work. Suggestions anyone?