Conditional Formating

[JBoyer]

I want to format cells between 0 and .66 to have a red fill color. I want
this to include zero but I don't want it to include a blank cell. However
when I try to use conditional formating it fills the blank cells with red. Is
there anyway I can fix this?

 

[Pete_UK]

Suppose the cell(s) you want to affect start with A1. Put this in the
Formula box of the CF dialogue box:

=AND(A1<>"",A1>=0,A1<0.66)

Hope this helps.

Pete

 

[JBoyer]

Thanks Pete, works great, couldn't figure out at first why it wasn't
including .66, but quickly realized i didn't have "<=". But anyway THANKS A
LOT!

 

[Pete_UK]

Ah!, you said you wanted it between 0 and 0.66, but to include zero.

Anyway, it's good to hear that you got what you wanted - thanks for feeding
back.

Pete