Conditional formatting acting oddly?

[Merboo]

Hi everyone,

I'm using conditional formatting in a range of cells. I have three rules, >=85% makes the cell green, cells with a value between 70% and 84.9% are yellow, and cells with a value <=69.9% are red.

However, when the cells show either 70% or 85%, they seem to ignore the rules and stay white. Would anybody be able to advise me on where I'm going wrong?

A formula is feeding into these cells to make the percentages. When I cleared the formula out and put in 70% or 85% manually, the formatting works okay, it just doesn't seem to work with the formulas in there.

The formulas are:

=AVERAGE(C19:L19)

=IF(AND(K2<2,K2>2),0,IF(K2=2,(I2/H2),0))

=IF(AND(K2<2,K2>2),0,IF(K2=2,(AVERAGE(D20,D22)),0))

Thanks!