Formula help please

[dougie]

IWOULD LIKE TO PUT A VALUE OF EITHER YES OR NO IN COLUMN C2. sHOULD THE VALUE BE NO, then I WOULD LIKE CELL D2 TO SAY YES AND VICE VERSA. cAN THIS PLEASE BE DONE.

In addition like to ensure that the value of YES OR NO is put into these cells so can some validation please be given to stop the rest of the row being filled in. ie e2 f2 etc.

Many Thanks

Dougie

 

[timorrill]

This should get you started:

Book1
	B	C	D	E
1
2		Yes	No
3		No	Yes
4
5
Sheet1

As for Data Validation, here's a suggestion to get you started:

Select Column C (or wherever the Yes/No values will be put). On the "Data" menu select "Validation...". On the Settings tab, choose "List" in the Allow field, and type "Yes, No" in the Source field (without the quotation marks). This is an easy way to allow only the values of Yes and No.

Without going into VBA code, I'm not sure how to disable other cells based on the Yes or No value that is given.

 

[dougie]

thanks

thanks for that,

Would it help to put the validation in column E so that if a person tried to enter a value in the column a message could read "please answer cells c2/d2"

Thanks