Conditional dropdown list

I know how to make a doropdown list using Data>Validity, but is there a way to feed data based on condition?

lets say I have a table whee column A have fruit names, bolumn B have amounts
like:

A      |  B
Apple  |  1
Banana |  3

to make droplist i would do Validity > cell range > $Sheet1.$A$1:$A$2

but what if I want to include only fruits that have amount value of more than 1 in column B ?
is there any way to make Custom criteria to inlude those cells where value in B > 1?

I know this can be done if i make two lists, one with values <=1 and other with >1, however with values changing often, those would need to be recreated, therefore i wonder if this can be achieved with just one table

Hello, @CFury

validacao

2 Likes

Thanks a lot

1 Like