Conditional Formating
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" wrote in message
...
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?
|