ExcelBanter - Lock Cell Conditionally

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Lock Cell Conditionally (https://www.excelbanter.com/excel-discussion-misc-queries/151990-lock-cell-conditionally.html)

Katherine R

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?

Jim Thomlinson

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?

All times are GMT +1. The time now is 07:15 PM.