Mutually exclusive cells - Excel 2003

[Kathleen]

Hi,

I am using a drop down list for picking a point scale (5, 3, 1, 0) in b1.
In another cell, C2, I have drop down box for N/A (-, Yes). If a point is
not chosen in B1, is there a way to have C2 automatically go to Yes?

Kathleen

 

[ryguy7272]

One of these should give you what you want:
http://www.contextures.com/xlDataVal13.html
http://www.contextures.com/xlDataVal02.html


Regards,
Ryan---

 

[Spiky]

One of these should give you what you want:http://www.contextures.com/xlDataVal13.htmlhttp://www.contextures.com/xlDataVal02.html

Regards,
Ryan---

In this case, a simple IF might work, instead of the drop down. Using
a drop down suggests user input, but "automatically" suggests no user
input.
=IF(B1="","Yes","-")