• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Validation (DV): How to add multiple DV for a cell

I

inddon

Member
Hello There,

I have a data validation (DV) on a field (C4), with a list (drop down).
Allow : List
Source: =Division


I want to add a custom validation in B4 and C4. It gives the below message:

"The selection contains some cells without Data Validation settings. Do you want to extend Data Validation to these cells?

If I click on 'No', the DV is cleared.

I I say 'Yes', then the DV on field C4 shows up
Allow : List
Source: =Division

I would like to add type 'Custom' and the =COUNTA($B4:$C4)=2


Could you please advise, on how this can be achieved?

Thanks & regards
Don
 
Hi Don ,

I don't think you can have multiple data validations in one cell ; you can use VBA to ensure that both B4 and C4 are populated.

Narayan
 
Dear Don

If I understand your requirements correctly which is that C4 should only accept input if there is something in B4, and when B4 has something in then the input must come from the list division.

To achieve this effect then In the data validation for C4 (allow list) use this formula.

=IF(B4<>"",Division,INDIRECT("Nothing"))

I credit the contextures blog for teaching me this. I generally find it to be an excellent resources for all things data validation related.
 
You must log in or register to reply here.
Back
Top