I have applied conditional formatting so that if the cell value is less than .75 (which shows as a percentage) the font turns red, if the cell value is greater than or equal to .75 it will turn green. This seemed to work find yesterday but today when I test it out, the cells are only turning green even if the cell value is less than .75.

When I highlight the cells that are not formatting correctly and select Manage Rules, the rule for it to turn red is still there so I just resave the rule as is, and then it works.

Why is this happening?