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

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


Regards,
Ryan---

--
RyGuy


"Kathleen" wrote:

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

On Jul 16, 6:33 pm, ryguy7272
wrote:
One of these should give you what you want:http://www.contextures.com/xlDataVal...DataVal02.html

Regards,
Ryan---

--
RyGuy

"Kathleen" wrote:
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

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","-")