We’re happy to announce a highly requested improvement to the Conditional Formatting dialogs in Excel for Windows. If you're a Microsoft 365 subscriber, they’re now resizable so you can see more rule...
Updated May 17, 2021
Version 3.0
Blog Post
Does anything work on Excel Online?
I need to animate a dashboard that provides end users access to conduct what if studies based upon my clients statistical analysis of survey results. To go online would be attractive but I lose the event handlers that increment or decrement user settings or selections, form controls that could be used instead also disappear. I think slicers might work and I might be able to use the presence or absence of variables within a hidden pivot table to toggle settings?
It might be that the functionality I need has disappeared to Power Automate, but I wouldn't guarantee that and, in any case, neither I nor the end-users have access to Power Automate to the best of my knowledge.
Currently my choice of code platform is Excel 365 insider beta and my beloved Office 2010 is consigned to the trash can.