Lock Cell Conditionally

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top