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