View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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?