Inconsistent conditional format with negative values

[MoxieQA]

I'm using conditional format to turn a number to red font when "cell value is less than -0.0002"

Sometimes the font turns red and others it stays as black font when the value is -0.0002. Ideas why it sometimes works and other times it does not? The format I'm using is "number"

[Ron Coderre]

Can you post ALL of the details of your Conditional Formatting settings?

[sglife]

Try changing the format of "Decimal places" to 30 and checking if it is exactly -0.0002