conditional formatting

[Jonbob]

I am trying to do conditional formatting if a cell value is:

Between 0 & .33
Between .33 & .66
.66 & Up

I have so far for the criteria:

Criteria # 1 =(between(C61>0,C61<0.33))
Criteria # 2 =(between(C61>.33,C61<0.66))
Criteria # 3 =C61>0.66

The first 2 don't seem to work...

please help..

Thanks,
Jonbob

 

[fairwinds]

Try:

Criteria # 1 =AND(C61>0,C61<0.33)
Criteria # 2 =AND(C61>.33,C61<0.66)
Criteria # 3 =C61>0.66

 

[staticbob]

try using less than . .

Criteria 1 = Cell value is less than 0.33
Criteria 2 = Cell Value is less than 0.66
Criteria 3 = Cell value is greater than or equal to 0.66

This should work ok
Bob