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