Hi, I am new to this forum, and a bit of an Excel newbie, so if this covers easy or old ground, apologies.
I would like to create a rule that governs what a user can input into a cell with that rule reflective of an entry in a different cell.

A1 is a simple list from which the user can choose either Yes or No.
- If user selects "Yes", than cell B1 would offer a separate list of text entries from which to choose
- If user selects "No", than cell B1 is automatically populated with "N/A"

Same A1 cell above
- If user has selected Yes, than cell C1 can be populated by the user with a number
- If user selects No, than cell C1 is automatically populated with "N/A".

I can't figure out to combine an IF condition in which one result of the true/false operation is the user must enter data into the cell, whether text or a number, while the other option the cell is not applicable.

Thanks for the help.