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
Bookmarks