Nested Conditional Functions

[DyingIsis]

This may be simple for everyone else except for me.

I have a spreadsheet in which each column I can fill in one of three options
(N/A, Yes, No). This is done with a list drop down box.

I would like to make sure that if I put "N/A" in A1, then B1, C1, D1, etc
are also N/A.

I would like that if I put "Yes" or "No" in B1 when I already put "N/A" in
A1, B1 would be highlighted in some what that tells me I created an error.

Any solution which addresses what I would like to happen will be really
appreciated.

Thanks for your help in advance.

 

[Bob Phillips]

Change the validation in B,C and D tp a Custom type with a formula of

=IF($A15="N/A",B15="N/A",ISNUMBER(MATCH(B15,$O$1:$O$3,0)))

 

[Paul C]

First put a formula in B1, C1, D1 etc (you may need to set the data
validation error level to info first)

=IF($A$1="N/A",$A$1,"")


Tthen use conditional formatting to highlight your second condition. Start
in cell B1

Choose the use a formula option and make your formula
=AND($A1="N/A",B1<>"N/A")

Pick a format (like red shading)

Once you apply this to B1 you can expand the range to apply to all your cells