Multiple Data Validation and Restrictions

[SuperCoog]

I have an excel sheet that I am attempting to apply restrictions to and also requires a drop down list.

End Goal: I want to make it to where a user has to select a cell in COLUMN A, choose a value from a drop down list (drawn from COLUMN D), before inputting any data in the corresponding cell in COLUMN B.

So far, I have set a data validation that restricts data being entered into COLUMN B if the corresponding cell in COLUMN A is blank. I have set it to where a warning pops up and tells the user what they need to do before inputting that data.

Where I am stuck is if the user inputs data in COLUMN A and then COLUMN B like I want, if the data in COLUMN A is deleted for whatever reason, there is nothing stopping the value in COLUMN B from remaining.

I'm looking for a way to restrict it both ways (avoiding using macros), but still keep the drop down menu.

[TABLE="width: 100"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Type
[/TD]
[TD]Data
[/TD]
[TD][/TD]
[TD]Data List
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]2
[/TD]
[TD]20
[/TD]
[TD][/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]4
[/TD]
[TD]40
[/TD]
[TD][/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]5
[/TD]
[TD]50
[/TD]
[TD][/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10
[/TD]
[/TR]
</tbody>[/TABLE]


Any help is appreciated

 

[oldbrewer]

you could conditionally format column B pattern = black so hiding what is in column B

 

[SuperCoog]

Thanks for the reply. I've put a condition similar to that, but I need an actual restriction just in case the visual queue isn't noticed. The reason being there are sums and various formulas in the rest of the spreadsheet that will be incorrect if the data is left without a value in column A

 

[oldbrewer]

ok, so in all those other formulas insert =if(A2="","", your formula here)) < < < extra close bracket