These rules worked for me
for the blanks: =ISBLANK(A1)
for the zeros: =AND(ISNUMBER(A1),A1=0)
for the 0<11= =AND(A10,A1<11)
The 'trick' was ISNUMBER in the zero check! Otherwise it captures the blanks
also.

best wishes


"Rookie Access User" wrote in
message ...
I want the background of a cell one color if it holds a value of 0, another
color if it is null or empty, and another color if the value is 0<11. It
seems that Excel treats 0 and an empty cell the same. Whatja think?