Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation to force entry in a cell
Hi,
I need validation on a cell where if any value is entered in one cell the user MUST enter a value in an adjacent cell. This must be easier than I'm making it.. e.g If they enter a number in say A2, a I need to ensure they can't progress without also entering a number in A3. Equally, if they enter a number in say A3, a I need to ensure they can't progress without also entering a number in A2. The numbers have logical relationship (i.e <=) , but are mutually exclusive, I can't have one without the other. Is this a custom formula in the Validation box? |
#2
|
|||
|
|||
Amendment! (why no Edit function!"
Should read "The numbers have NO logical relationship (i.e <=) , " "Matt D Francis" wrote: Hi, I need validation on a cell where if any value is entered in one cell the user MUST enter a value in an adjacent cell. This must be easier than I'm making it.. e.g If they enter a number in say A2, a I need to ensure they can't progress without also entering a number in A3. Equally, if they enter a number in say A3, a I need to ensure they can't progress without also entering a number in A2. The numbers have logical relationship (i.e <=) , but are mutually exclusive, I can't have one without the other. Is this a custom formula in the Validation box? |
#3
|
|||
|
|||
The big question here is what do you mean by "progress"? You can setup code
to check if both cells are occupied when the user selects any cell other than A2 & A3. Or if he tries to save the file. Or if he tries to close the file. In short, what do you want the user to NOT be able to do unless those two cells are occupied? HTH Otto "Matt D Francis" wrote in message ... Hi, I need validation on a cell where if any value is entered in one cell the user MUST enter a value in an adjacent cell. This must be easier than I'm making it.. e.g If they enter a number in say A2, a I need to ensure they can't progress without also entering a number in A3. Equally, if they enter a number in say A3, a I need to ensure they can't progress without also entering a number in A2. The numbers have logical relationship (i.e <=) , but are mutually exclusive, I can't have one without the other. Is this a custom formula in the Validation box? |
#4
|
|||
|
|||
Hi Otto.
I think just not saving the worksheet would be sufficient. It maybe they don't have that exact data to hand at that moment, but it definitely needs to be there before the workbook is saved. I thought it would be coding, but was hoping it wasn't! Matt "Otto Moehrbach" wrote: The big question here is what do you mean by "progress"? You can setup code to check if both cells are occupied when the user selects any cell other than A2 & A3. Or if he tries to save the file. Or if he tries to close the file. In short, what do you want the user to NOT be able to do unless those two cells are occupied? HTH Otto "Matt D Francis" wrote in message ... Hi, I need validation on a cell where if any value is entered in one cell the user MUST enter a value in an adjacent cell. This must be easier than I'm making it.. e.g If they enter a number in say A2, a I need to ensure they can't progress without also entering a number in A3. Equally, if they enter a number in say A3, a I need to ensure they can't progress without also entering a number in A2. The numbers have logical relationship (i.e <=) , but are mutually exclusive, I can't have one without the other. Is this a custom formula in the Validation box? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Validation | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Cell Validation | Excel Discussion (Misc queries) | |||
how to add two data validation lists to a single cell? | Excel Worksheet Functions |