TKnTexas55

Conditional Formatting Problem

Discussion created by TKnTexas55 on Jan 21, 2019
Latest reply on Jan 21, 2019 by comment

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.

And I get:

I did try to use = 0 or =-0, and that did not work. Suggestions anyone?

Outcomes