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?