If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Validate entry based on another cell value
How do I set up validation of data entry in cell B1 depending on the value
entered in cell A1? Valid entries for B1 are - blank if A1 1 or N or E if column A1 zero. |
#2
|
|||
|
|||
Validate entry based on another cell value
One thing to note, you can't force a user to either leave a cell empty or
enter something. There are little things you can do to try to coax them to follow those rules but in the end the user has all the power. ( the ON/OFF switch!) So, try this: Select cell B1 Goto the menu DataValidation AllowCustom Formula: =AND(COUNT(A1),A10,OR(B1="N",B1="E")) Uncheck the "Ignore blank" checkbox. If you want custom messages to appear select the Input Message and/or Error Alert tabs and fill in the info. OK out -- Biff Microsoft Excel MVP "Dearoledad" wrote in message ... How do I set up validation of data entry in cell B1 depending on the value entered in cell A1? Valid entries for B1 are - blank if A1 1 or N or E if column A1 zero. |
#3
|
|||
|
|||
Validate entry based on another cell value
Thanks, Biff. It worked perfectly. As for a user not entering anything, I
have devised a gorella that reaches out of the screen and shakes the user if they skip the field when they should be entering data. Thanks again. "T. Valko" wrote: One thing to note, you can't force a user to either leave a cell empty or enter something. There are little things you can do to try to coax them to follow those rules but in the end the user has all the power. ( the ON/OFF switch!) So, try this: Select cell B1 Goto the menu DataValidation AllowCustom Formula: =AND(COUNT(A1),A10,OR(B1="N",B1="E")) Uncheck the "Ignore blank" checkbox. If you want custom messages to appear select the Input Message and/or Error Alert tabs and fill in the info. OK out -- Biff Microsoft Excel MVP "Dearoledad" wrote in message ... How do I set up validation of data entry in cell B1 depending on the value entered in cell A1? Valid entries for B1 are - blank if A1 1 or N or E if column A1 zero. |
#4
|
|||
|
|||
Validate entry based on another cell value
a gorella that reaches out of the screen and shakes the user
I like that idea! Thanks for the feedback! -- Biff Microsoft Excel MVP "Dearoledad" wrote in message ... Thanks, Biff. It worked perfectly. As for a user not entering anything, I have devised a gorella that reaches out of the screen and shakes the user if they skip the field when they should be entering data. Thanks again. "T. Valko" wrote: One thing to note, you can't force a user to either leave a cell empty or enter something. There are little things you can do to try to coax them to follow those rules but in the end the user has all the power. ( the ON/OFF switch!) So, try this: Select cell B1 Goto the menu DataValidation AllowCustom Formula: =AND(COUNT(A1),A10,OR(B1="N",B1="E")) Uncheck the "Ignore blank" checkbox. If you want custom messages to appear select the Input Message and/or Error Alert tabs and fill in the info. OK out -- Biff Microsoft Excel MVP "Dearoledad" wrote in message ... How do I set up validation of data entry in cell B1 depending on the value entered in cell A1? Valid entries for B1 are - blank if A1 1 or N or E if column A1 zero. |
Thread Tools | |
Display Modes | |
|
|