Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

I would like a data validation formula that prevents entry into range AB3:AB18 if the…

  1. 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

  2. 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.