| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I restrict what is entered in the next cell?
Hi,
I have a list of codes from number 200 to 900. For all codes 400 and under a clients name needs to be added in the next cell. For all codes over 400 there does not need to be a client in the next cell. How can make it so when someone enters the code 400 or under they have to enter a clients name in the next cell? Tx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I restrict what is entered in the next cell?
If the codes are entered in column A then in C1 enter:
=IF(A1="","",IF(A1400,"",IF(B1<"","","enter a name in column B"))) and copy down This will expose a reminder that the client name has not been entered in column B -- Gary''s Student - gsnu200793 "Jen" wrote: Hi, I have a list of codes from number 200 to 900. For all codes 400 and under a clients name needs to be added in the next cell. For all codes over 400 there does not need to be a client in the next cell. How can make it so when someone enters the code 400 or under they have to enter a clients name in the next cell? Tx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I restrict what is entered in the next cell?
Thanks for that, but I want to be able to enter information into C column
also. "Gary''s Student" wrote: If the codes are entered in column A then in C1 enter: =IF(A1="","",IF(A1400,"",IF(B1<"","","enter a name in column B"))) and copy down This will expose a reminder that the client name has not been entered in column B -- Gary''s Student - gsnu200793 "Jen" wrote: Hi, I have a list of codes from number 200 to 900. For all codes 400 and under a clients name needs to be added in the next cell. For all codes over 400 there does not need to be a client in the next cell. How can make it so when someone enters the code 400 or under they have to enter a clients name in the next cell? Tx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| restrict cell content display | Excel Discussion (Misc queries) | |||
| Restrict cell deletion | Excel Discussion (Misc queries) | |||
| Restrict User to specific 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) | |||
Linear Mode
