| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock Cell Conditionally
I'm a novice using Office 2003. If the value in cell G17 is greater than or
equal to 4:45 PM, I would like cell G18 to be locked to prevent an entry. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock Cell Conditionally
You could use Data - Validation - Custom - =G17<TIMEVALUE("16:45:00")
placed in Cell G18. You will want to change the error message to let the user know why data entry in G18 is not valid. -- HTH... Jim Thomlinson "Katherine R" wrote: I'm a novice using Office 2003. If the value in cell G17 is greater than or equal to 4:45 PM, I would like cell G18 to be locked to prevent an entry. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditionally lock a Cell | Excel Worksheet Functions | |||
| Lock cell control conditionally? | Excel Discussion (Misc queries) | |||
| How can you lock cell conditionally | Excel Discussion (Misc queries) | |||
| conditionally lock cells? | Excel Discussion (Misc queries) | |||
| Lock and unlock cells conditionally depending on input in another | Excel Worksheet Functions | |||
Linear Mode
