Formula help please

dougie

New Member
Joined
Mar 24, 2004
Messages
45
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 :confused:
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

timorrill

Well-known Member
Joined
Sep 20, 2006
Messages
528
This should get you started:
Book1
BCDE
1
2YesNo
3NoYes
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

New Member
Joined
Mar 24, 2004
Messages
45
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
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,538
Members
410,547
Latest member
htran4
Top