hi all,

I have an overtime sheet which I am developing.

In column a, there is data validation so they can pick 'On Call', 'Working' and now 'Early Shift'.

Column D is for time entry. However if they select Early Shift, I do not need to record the time, so would like the cell on the corresponding row in columnn D to become locked and change colour to show it does not require entry.

how could I do this?

Thanks a lot in advance