Hi there,

Is it possible to auto fill (and locked for manual fill) a validated cell only if the condition is not met? and let user to fill manually if the condition meet?

Example
possible cell A1 value = X, Y, or Z
Cell to be input and use data Validation = B1

User need to input in cell B1 based on A1 Value:
if A1 = A or B, cell B1 = 5 (and locked for editing with Data Validation)
if A1 = C, User can input any value in B1

Is there a way to do this with data validation?

Thank You
Regards