Formulas needed

[Moftah17]

would you please find me the way where I can do data validation to choose between restricted value and certain drop list based on another cell value ( for example )

if Cell (A4) less than 5 the (A10) will occur  as drop list , if (A4) > 5 the (A10) will be restricted value of  (Apple)

thanks a lot

[#2 · Accepted solution]

@Moftah17 

For example as in the screenshot below:

The source formula for data validation of A10 is

=IF(A4<5,$E$1:$E$5,$D$1)

 

[#3]

@Hans Vogelaar 

thanks a lot this one is worked as fine as i need 

i appreciate what you've done for me