Conditional Formatting

[s0nginmyheart]

Hello,

I have a spreadsheet where I can't seem to figure out why conditional formatting does not work in a certain cell.
Basically, I've formatted cells so that:
If VALUE >0, then (red)x
If VALUE ≤0, then (green) ✓

It appears to work on one cells with values at 0 (L18) but if I toggle some of the numbers elsewhere, particularly L24 to make that amount 0, I get a (red)x and not a (green)✓

Can somebody show me what is it that I am doing wrong?

Thanks in advance.

[Jonmo1]

I would suspect that the value in your cell is not EXACTLY 0.
It could be 0.00001 or something like that.
Possibly due to floating point precision issues with storing decimal numbers.

Try adjusting your formula in column L to
=ROUND(SUM(C11-K11),2)

[s0nginmyheart]

Thank you. I plugged in the following formula in L24:
=ROUND(SUM(C24-K24),2)
and it makes cell L24 green now, however if the value is exactly 0, I just get a "$-" value now to represent zero. How can I get that back to a $0.00 figure?

Also, why in the formula do you do the part below (in bold)? ETA - Googled this --- Is the ,2 for two decimals?
=ROUND(SUM(C24-K24),2)

[Jonmo1]

That is in the standard cell formatting.
In the standard cell formatting, choose custom and put
_($* #,##0.00_);_($* (#,##0.00);_($* #,##0.00_);_(@_)

The 2 is telling ROUND how many decimal points to round the value to.
You can change that to whatever number you like 0 to 15

[s0nginmyheart]

Great. I formatted it back to Currency. This works. Thank you so much!

[Jonmo1]

You're welcome.