You aren't the first person to want to do this and a google search (with the right terminology) will reveal several approaches.
http://lmgtfy.com/?q=excel+conditional+data+validation

This one looks good
https://www.excel-university.com/cre...ta-validation/

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia