| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation to restrict input in cell based on value of cell above that cell
Hi all,
i am creating a spread sheet in which users are supposed to enter data in one column. i want to add validation in such a way that user will not be able to enter data in the say cell "C1" if he has not entered value in cell "B1"i.e if "B1" is blank Can anybody plz help Thanks in advance Regards NC |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation to restrict input in cell based on value of cell above that cell
A previous post by Debra Dalgleish
http://groups.google.co.nz/groups?hl...r esXSPAM.com Select cell A2 Choose DataValidation Choose to Allow:Custom In the Formula box, type: =A1<"" Remove the check mark from 'Ignore blank' Click OK -- Rob van Gelder - http://www.vangelder.co.nz/excel "NC" wrote in message oups.com... Hi all, i am creating a spread sheet in which users are supposed to enter data in one column. i want to add validation in such a way that user will not be able to enter data in the say cell "C1" if he has not entered value in cell "B1"i.e if "B1" is blank Can anybody plz help Thanks in advance Regards NC |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation to restrict input in cell based on value of cell above that cell
thanks rob
it works fine regards NC |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation won't restrict user input - please help | Excel Discussion (Misc queries) | |||
| Can i restrict input in a cell until previous cell populated? | Excel Discussion (Misc queries) | |||
| Restrict entry in one cell based on second cell | Excel Discussion (Misc queries) | |||
| how do I restrict cell input to dates only? | Excel Discussion (Misc queries) | |||
| Restrict input into cell array | Excel Discussion (Misc queries) | |||
Hybrid Mode
