Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format painter wont copy mixed font colors from one cell to next | Excel Discussion (Misc queries) | |||
Format a cell to recognize data and change font colors accordingly | Excel Worksheet Functions | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Conditional Formatting Question - Different Cell Colors?? | Excel Discussion (Misc queries) | |||
How to carry over conditional format colors to a chart | Charts and Charting in Excel |