How to setup a 'chooser' box/cell for Y or No?
1)Yes, if you check the "Apply these changes....", then all other cells using
that same Data Validation will use the changes.
2)Why would you want to have a blank space in the list????? I hope it's not
to accommodate people who "erase" cells by putting a space in them.
***********
Regards,
Ron
XL2002, WinXP-Pro
"Pheasant PluckerĀ®" wrote:
Thanks for the reply Ron,
Brilliant, spot-on!
I am never amazed at what Excel can achieve but I am regularly reminded of
my own ignorance! ;^)
A couple of questions if you don't mind Ron...
1. In the Data Validation box there is an option "Apply these changes to all
other cells with the same settings"
Should I expect this to alter all other cells with this same data validation
info if for example I make one change in the Data Validation requestor for
say cell A1 by adding N/A, after Y, N, ?
Should it then change cells A2:A60 by adding the N/A, to save me
copying/pasting A2:A60?
2. How would I enter a blank space in the list? Just hit the spacebar
followed by a comma?
Thanks & regards,
-=pp=-
"Ron Coderre" wrote in message
...
See if this satisfies your requirements.....
Select the input cells (I'll assume A2:A10).
DataValidation
Allow: List
Source: Y,N
Click the [OK] button
Select B2
B2: =IF(A2="N",1,"")
Copy that formula down as far as needed, replacing the 1 as necessary.
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Pheasant PluckerĀ®" wrote:
Sorry...don't quite know how to describe what I want to do...any
telepaths
out there? ;^)
In a spreadsheet I have a need for a cell to display Y or N.
Rather than type in Y or No I would like to be able to select either
option
by clicking on the cell and choosing Y or N from a small menu.
I have cut & pasted a similar cell from another spreadsheet so now when
I
click in the cell there is the grey square with a black arrow displayed
at
the right hand side of the cell.
On the spreadsheet I copied from there was this choice of Y or N but
this
did not seem to be copied over to my new spreadsheet.
There did not appear to be a formula to the cell either.
What is the proper name for what I am trying to do and how do I get the
auto-requestor cell to display either Y or N please?
Also is there a way to define a number value in the adjacent cell if N
is
selected & displayed?
For example for some entries where N is displayed I need to assign a
value
of 1 in the adjacent cell and for others I need to assign a value of 2,
3 4,
or 5.
Is this even possible?
--
Thanks & regards,
-pp-
|