I am looking for a way to have a cell default to a named cell if another cell has the answer "yes" and if the cell says "no" i want the user to be able to input any number. Any tricks out there that could solve my problem?