Hi -

I'm looking to see if there is a way to automatically update cells based on a selection. In cell C6 I have 4 options to choose from using data validation. If a selection of EE_only or EE+Child(ren) I would like to have cell C8 go to "N/A". However, cell C8 is also using data validation. Can anyone offer any suggestions?

Here is the layout
C6: has the options of EE_Only, EE+Spouse, EE+Child(ren), EE+Family through data validation
C7: has the option of Yes or no which is through data validation
C8: has the option of yes or no which is also through data validation. This cell is provided for those selecting EE+Spouse or EE+Family. I'm looking to have this cell update to "N/A" if EE_Only or EE+Child(ren) is selected.

Any help/suggestions is greatly appreciated.