You could use "Formula is" and then in the formula box put (without the
quotes) "=and(isnumber(C12),C12<5,C12-1)". Where C12 is the cell you want
colored.
Will

"tankerman" wrote:

I am trying to format several cells so that the background and text changes
color when the numbers 0,1,2,3 or 4 are entered but if any number higher
nothing is to be changed. My problem is when I use the CELL VALUE IS BETWEEN
function the cells change when blank but I don't what the changes when blank.
Is there a better function to use.