Data Validation Control based on another Cell.

[srizki]

Hi all,

I copy and paste dates in column, “M”, I want a data validation that if a corresponding cell in column, “H” house, “8500100”, the date should be 12-31-2017, otherwise leave it as is, whatever is copied.

Please advise.

 

[Joe4]

I think you are going to need to come at this from a different angle.
Without the use of helper columns or VBA, I don't think you can do what you want.
As you know, a cell can either have a hard-coded value or a formula in it, but never both at the same time.

Also, Data Validation would not do what you want anyway. That only limits what can be put in a cell. But Data Validation itself cannot populate the cell for you!

 

[srizki]

I just want that when I copy and paste the dates in that column, if the corresponding cell has 8500100, the date cell should give message, the date should be, "12-31-2017".
I think it will not work, so I put conditional formatting, so that way I can change it manually.

Thanks.

 

[Joe4]

The problem is Copying & Pasting overwrites Data Validation.
You could protect your sheet to protect the Data Validation, but that would disable the ability to Copy & Paste.

 

[srizki]

Catch 22