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:
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

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
 

Forum statistics

Threads
1,141,741
Messages
5,708,237
Members
421,553
Latest member
Geeyj

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top