Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I restrict data entry to one of two columns
I have a file with several fields to be entered. Two of the columns are date
fields (say columns E and F). What I want to happen is that if data is entered in row 3 of column E then it is not possible to enter data in row 3 of column F, and vice versa. I presume this would be some kind of conditional formatting, but I can't work out how to do this. I also need to do this in Excel 2000. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I restrict data entry to one of two columns
I'd use a formula in G3:
=IF(COUNTA(E3:F3)<2,"0k","Only one value!") or maybe something like: =IF(COUNTA(E3:F3)=0,"Please enter a value in E or F (not both)", IF(COUNTA(E3:F3)=1,"0k","Only one value!")) Gillian wrote: I have a file with several fields to be entered. Two of the columns are date fields (say columns E and F). What I want to happen is that if data is entered in row 3 of column E then it is not possible to enter data in row 3 of column F, and vice versa. I presume this would be some kind of conditional formatting, but I can't work out how to do this. I also need to do this in Excel 2000. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I restrict data entry to one of two columns
Data Validation.
In cell E1, go to Data--Validation Allow: Date Data: Greater than or equal to Start Date: =IF(F10,99999,0) Highlight column E (or at least down to where is needed), and go to Data--Validation, and select YES for extending data validation. Then in F1, do the same thing as in E, except the formula for start date will be E1, highlight column F, and go to Data--Validation, YES to extend, again, same as you did in column E. -- John C "Gillian" wrote: I have a file with several fields to be entered. Two of the columns are date fields (say columns E and F). What I want to happen is that if data is entered in row 3 of column E then it is not possible to enter data in row 3 of column F, and vice versa. I presume this would be some kind of conditional formatting, but I can't work out how to do this. I also need to do this in Excel 2000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
How can I restrict a cell(s) to alpha-only data entry? | Excel Discussion (Misc queries) | |||
Restrict entry types | Excel Discussion (Misc queries) | |||
can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
HOW TO RESTRICT DATA ENTRY FROM A CHOICE OF SEVERAL LIST? | Excel Discussion (Misc queries) |