Data validation

I need to make validation list but work only if another cell is not blank otherwise it not work

Simply I have a list in I5 cell contain data validation List of 1,2,3,4,5

I need this list work only If A5 is not blank

You can do this with a named range which is a formula. Go to the 'Formulas' tab and click 'Define Name'. Enter a name, for example 'ListIfA5NotBlank' and put this in the formula box:

Formula:

Please Login or Register  to view this content.

Change $Z$1:$Z$5 to where you have the numbers 1 to 5 stored.
Click OK.

Before going any further, make sure you have something in A5 - any number/letter will do.

Now select I5 and go to Data Validation. Select 'List' and enter your named range as the source:

Formula:

Please Login or Register  to view this content.

Click OK.

Now you'll see the drop-down list in I5. If you delete the value in A5 the drop-down won't work.

Warning - if you select something from the list, then delete the value in A5, the previously selected value will still be there - it won't automatically disappear. You can delete it manually, but to get it to automatically delete would need VBA.

Hope that does what you want.

As you've marked the thread as solved, I assume the above worked for you. Thanks for the rep as well.