well without seeing the file and the values its hard to say

The most likely reason is the values are actually text and hence do not meet the criteria and fall in the range.
if the first value is in cell a1, choose formula

try =and(a1>0.5,a1<0.7) as the first condition etc

Regards

Dav