| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating IS: Help With ANY VALUE
I am using conditional formatting in regards to a form that needs to be
filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating IS: Help With ANY VALUE
Format the cells yellow to begin with, then set the CF criteria as follows
CellValueIs....NotEqualTo.....="" Vaya con Dios, Chuck, CABGx3 "Paperback Writer" wrote: I am using conditional formatting in regards to a form that needs to be filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating IS: Help With ANY VALUE
Can't you just set your condition like this?
Cell Value Is -- equal to -- 0 "Paperback Writer" wrote: I am using conditional formatting in regards to a form that needs to be filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating IS: Help With ANY VALUE
What if they key in "0" for the value? That is a real possibility.
"jjones" wrote: Can't you just set your condition like this? Cell Value Is -- equal to -- 0 "Paperback Writer" wrote: I am using conditional formatting in regards to a form that needs to be filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating IS: Help With ANY VALUE
How about the ISBLANK function?
=ISBLANK(A1)=FALSE HTH, Elkar "Paperback Writer" wrote: What if they key in "0" for the value? That is a real possibility. "jjones" wrote: Can't you just set your condition like this? Cell Value Is -- equal to -- 0 "Paperback Writer" wrote: I am using conditional formatting in regards to a form that needs to be filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating IS: Help With ANY VALUE
Change Condition 1 to Formua Is and add a formula of
=LEN(A2)0 assuming the first selected cell is A2 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Paperback Writer" wrote in message ... What if they key in "0" for the value? That is a real possibility. "jjones" wrote: Can't you just set your condition like this? Cell Value Is -- equal to -- 0 "Paperback Writer" wrote: I am using conditional formatting in regards to a form that needs to be filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating IS: Help With ANY VALUE
Conditional Formatting
Conditiuon 1 Formula is –¼ =A1="" Select [Format] "Paterns" Tab, choose your color. Any enrty including a space will negate the formula and remove the chosen color. Lou I think CLR's method works also "Elkar" wrote: How about the ISBLANK function? =ISBLANK(A1)=FALSE HTH, Elkar "Paperback Writer" wrote: What if they key in "0" for the value? That is a real possibility. "jjones" wrote: Can't you just set your condition like this? Cell Value Is -- equal to -- 0 "Paperback Writer" wrote: I am using conditional formatting in regards to a form that needs to be filled out. As the user fills out the required fields, the fields change from YELLOW to WHITE. Trouble I am having is alpha-numerics. I need an "IS" statement that allows me to change the cell from YELLOW to WHITE whenever ANY VALUE is placed into the particular cell. I need something like: =ISANYVALUE(A1) THANK YOU |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating is greyed out and unavailable | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| excel conditional formating decimal fractions | Excel Worksheet Functions | |||
| Conditional formating using formulas | Excel Worksheet Functions | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Linear Mode
