Conditional Formating

  • Thread starter Thread starter JBoyer
  • Start date Start date
J

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?
 
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
 
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!
 
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
 
Back
Top