View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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?