Hi, hoping for some help.

I have two Data Validation lists. The first contains:
None
Web
Inhouse

the second contains:
Yes
No

Is it possible for the second to auto populate to 'No' if they select 'None' from the first list? Thanks