Forum Discussion
AlexandreSobrinho
Apr 26, 2023Copper Contributor
Data Validation with searchable drop-down list
Hello everybody!
The data validation feature with searchable list in Microsoft 365 Excel in the online version works perfectly.
Why in the offline version of the same program does not work?
Will this feature be available at some point in the offline (desktop) version?
- a custom formula in conditional formatting will apply the formula to the top left most cell in the 'Applied to' range and then move to each other cell in the range and adjust the formula relative to that next cell location. So lets pretend the gray columns are A:B and you highlight columns C:I and create new rule. Then Enter:
=ISNUMBER(C1)*((C1>$A1)+(C1>$B1))
So C1 is the top left corner of the range so If C1 is a number AND > either A1 or B1 it is true
Then when excel looks at D1 it replaces each C1 with D1 in the formula but the $ before the A and the B tell it to Lock them and not change. And similar when it goes to row 2 all the 1s become 2s.
2 Replies
Sort By
- JKPieterseSilver ContributorIt is being introduced to Excel desktop in Microsoft 365 subscriptions, but it may take a while to show up for you, depending on which update cycle you are on.
- AlexandreSobrinhoCopper ContributorThis is the best answer I hope to receive. Many thanks for informing!