Restricting Input

  • Thread starter Thread starter Randy Vieira
  • Start date Start date
R

Randy Vieira

Ok, I'm on a roll here. Could someone please tell me how to set up a cell
restriction that will only allow data input if another cell is "empty" or
has a certain value? Kind of like an IF function, only when "true" exists,
I can input any value, and when "false" exists, I must leave it blank.

Thanks in advance.

Randy,
 
you can accomplish this using data validation. Select: data-validation,
then input your restriction.
 
Ok, I thought so, but I don't know how to specify "any value". You know,
like "" means blank..

Any help?

Randy,
 
How about:
Allow: Custom
formula is: =A1=""

(to allow entry only when A1 is "".)

Or
formula is: =A1<>""
if A1 has to have something in it first.

====
Remember that this stuff isn't retroactive. If your user puts something in B1
and later enters something in A1 (or cleans up A1), the B1 value doesn't get
validated again.
 
I'll give that a shot then, thank you. Too bad it isn't retro-active, but I
guess some accountability must be passed on to the user input.

Randy,
 
Hi Randy

A spreadsheet is a very liberal thing, so they're not much good for forcing
or restricting user inputs. I think you would be better off with a
userform -not really knowing what you're building, just an impression.

Best wishes Harald

Randy Vieira said:
I'll give that a shot then, thank you. Too bad it isn't retro-active, but I
guess some accountability must be passed on to the user input.

Randy,
Click to expand...
 
Back
Top