MENUS
I built a short presentation video demonstrating how to use dynamic arrays and conditional formatting to create a selection dependent menu.
Though I built this spreadsheet menu using Excel on a desktop machine, the spreadsheet file also works on an iPad ( ! ) and on an iPhone ( !! ).
Microsoft 365 is required.
Google Search
TRY THIS
The MP4 video was recorded on an iPad and published using Camtasia 2020.
![Overall no formulas](http://khoitsmahq.firstcloudit.com/images%2FOverall%20no%20formulas.png)
![Overall with formulas](http://khoitsmahq.firstcloudit.com/images%2FOverall%20w%20formulas.png)
![Overall with formulas](http://khoitsmahq.firstcloudit.com/images%2FData.png)
![Name Manager](http://khoitsmahq.firstcloudit.com/images%2FName%20Manager.png)
![Data Validation](http://khoitsmahq.firstcloudit.com/images%2FData%20Validation.png)
![Menu 1 Pull Down Array](http://khoitsmahq.firstcloudit.com/images%2FMenu%20Pull%20Down%20Range.png)
![Menu 1 Pull Down](http://khoitsmahq.firstcloudit.com/images%2FMenu%20Pull%20Down.png)
![Pulldown is in Cell H4; calculated values in Cells J4 and J5](http://khoitsmahq.firstcloudit.com/images%2FOverall%20w%20formulas.png)
The data range is conditionally formatted to match the selection
![Conditional Formatting](http://khoitsmahq.firstcloudit.com/images%2FConditional%20Formatting.png)