| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is it possible to make certain cells required based on criteria
I am trying to lock and unlock certain cells based on data input into a cell.
Is this possible? Example: If user types "New" into Cell A1, then lock Cells A2 and A3, and put cursor into Cell A2 ready for next input. If user types "Existing" into Cell A1, then unlock Cells A2 and A3, but lock Cells A4 and A5. Then put cursor into Cell A4 ready for next input. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| Count text cells based on two criteria | Excel Worksheet Functions | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Hybrid Mode
