Cell colors on conditional format
 

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.

Cell colors on conditional format
 

Use the "Formula Is" option:

Formula Is: =AND(ISNUMBER(A1),A1<=4)

Biff

"tankerman" wrote in message
...
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.

Cell colors on conditional format
 

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.

Cell colors on conditional format
 

Use "formula is" in conditional formatting

say its cell u10 you wish to apply format, in this cell apply the
conditional formatting and type

=IF(AND(U10<5,U10<""),TRUE,FALSE)

Then apply your format.
--
This post was created using recycled electrons!


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

Cell colors on conditional format
 

Formula Is: =AND(ISNUMBER(A1),A1<=4)

That'll work as long as the numbers are always positive. If you need to
account for any negative values:

=AND(ISNUMBER(A1),A1=0,A1<=4)

Biff

"T. Valko" wrote in message
...
Use the "Formula Is" option:

Formula Is: =AND(ISNUMBER(A1),A1<=4)

Biff

"tankerman" wrote in message
...
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.

Cell colors on conditional format
 

works, Thanks

"T. Valko" wrote:

Formula Is: =AND(ISNUMBER(A1),A1<=4)

That'll work as long as the numbers are always positive. If you need to
account for any negative values:

=AND(ISNUMBER(A1),A1=0,A1<=4)

Biff

"T. Valko" wrote in message
...
Use the "Formula Is" option:

Formula Is: =AND(ISNUMBER(A1),A1<=4)

Biff

"tankerman" wrote in message
...
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.

Cell colors on conditional format
 

You're welcome. Thanks for the feedback!

Biff

"tankerman" wrote in message
...
works, Thanks

"T. Valko" wrote:

Formula Is: =AND(ISNUMBER(A1),A1<=4)

That'll work as long as the numbers are always positive. If you need to
account for any negative values:

=AND(ISNUMBER(A1),A1=0,A1<=4)

Biff

"T. Valko" wrote in message
...
Use the "Formula Is" option:

Formula Is: =AND(ISNUMBER(A1),A1<=4)

Biff

"tankerman" wrote in message
...
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.