Hi,

I am trying to use Data Validation - Validation List in C1. However, I want only users to choose from the list if A1=B1. If A1 is not equal to B1, an error message should show and the users cannot choose from the list. How do I do it?