Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it will save and show the colors. After I do that any time that criteria is met the formatting sticks, but as soon as I leave and come back it happens again.
There are underlying formulas to the data so I suppose that can be the issue, but I was just wondering if anyone else has experienced this issue. It is the first time I have seen it and we use conditional formatting often.