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
I see your point, but conditional formatting does give the feeling of being stuck in a time-warp; a homage to end-user computing as originally envisaged. It is distinctly out of keeping with the world of dynamic arrays and Lambda functions but I can well believe that it is easier to implement Lambda than make CF keep up. Even with traditional spreadsheets (one that I know kept track of conference paper submissions and rows were forever being moved as manuscripts were received or reassigned) the ranges defining the 10 overlapping CFs become an utter mess and require major repair at the end of each day.
With dynamic arrays it is possible to apply the CF to an oversize region to allow for continual resizing of the array; I have even applied CF to entire worksheets so that the dynamic range is visually defined by the CF, no matter how it changes. I half expected to crash Excel but it appears to perform OK as a workaround!