I have a column that already has Data Validation with Criteria: List from a range.

Now I want to show an error message every time a user selects a specific value from that column but has not entered anything in the adjacent cell in the same row. This has to work separately for each row. Is there a way of doing this?

migrated from superuser.com Jun 4 '18 at 19:51

This question came from our site for computer enthusiasts and power users.

  • IMO,This is only possible, If you ditch the dropdown or write a custom script invalidation – TheMaster Jun 4 '18 at 21:26
  • not directly but it can be faked – user0 Jul 8 '18 at 10:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy