You can do what you want using these 3 Conditional Format formulas (assuming
A1 is the active cell when you create them)...

Empty (Null) Condition: =A1=""

Zero Condition: =A1=0

Range Condition: =AND(A10,A1<11)

--
Rick (MVP - Excel)


"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?