gpt-3.5-turbo-0613· OpenAI
WildChat-4.8M (AI2)
I would like a data validation formula that prevents entry into range AB3:AB18 if the…
- User
I would like a data validation formula that prevents entry into range AB3:AB18 if the corresponding row value in range AA3:AA18 is blank
- Assistant
To prevent entry into range AB3:AB18 if the corresponding row value in range AA3:AA18 is blank, you can use the following data validation formula in cell AB3:
=NOT(ISBLANK(AA3))
Then, apply this validation rule to the range AB3:AB18. This formula will only allow entry in column AB if the corresponding cell in column AA is not blank.