Conditional Formating
 

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?

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?

Conditional Formating
 

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" wrote:

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?

Conditional Formating
 

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

"JBoyer" wrote in message
...
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" wrote:

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?